tOracleOutput : change DB column --> ORA-00904: : invalid identifier
Hi, On 2008-12-16 15:01:21 I posted a question "Exception in component tOracleOutput_1 ORA-00904: : invalid identifier" The postid is 5024 (5024) See that post reply for all the attached illustrations. The reponse was to use \" around the DB column names. The resolution is working, but rather as a workaround, because it inserts quotes around the values stored in the Db. After researching, I found that the ORA-00904: : Invalid identifier is appearing when you change the column name going to the DB (DB column in the interface). Creating the MetaData Schema (See Appended Img): Point 1-2 : The input File is "Value1";"Value2";... using this setting, I remove the quotes around the value Point 3-4 : The first line of the Input File is the Column name So use it for the column name. Bug ? Selecting Set heading as column name when creating the metadata schema is properly creating the schema with custom headers names, but after, when using it as input to tOracleOutput it creates ORA-00904: : invalid identifier when the Db column name is different from column0, ... I couldn't find a way to set the Db column name other than column0, ... as soon as the the Db column is names columnX it works. If I change DB column to something other, the error appears.