Oracle ORA-01747

[Anonymous]

TOS3.1.3 - java
Hello,
I'd like to load data in an Oracle database. This database has column name like this : 2000, 2001, 2002
When we wants write a query in Oracle with such column name we should write :
update mytable set "2000"='test'
But Talend generates code without quotes : update mytable set 2000='test'
So the folowing error occur : ORA-01747: spécification utilisateur.table.colonne, table.colonne ou colonne non valide
I did not found how set my OracleOutput component for adding quotes in the query. Is that possible or should I report a bug?
Thanks
José
PS : for the tOracleInput component I have manually modified the query in order to add quotes, that takes time but that works.

[Anonymous]

Hello
I want to know how do you create a table with some column names starts with digit?
Best regards

shong

[Anonymous]

I have checked the option "add quotes, when you generate sql statement" in the Talend's preferences.
It works well for tOracleInput component, but it does not work for the tOracleOutput component.

[Anonymous]

Hello
I want to know how do you create a table with some column names starts with digit?
Best regards

shong

With oracle 11 :
ALTER TABLE DBO.MYTABLE
ADD ("2002" NUMBER(15,4))