One Star

Oracle ORA-01747

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 Smiley Sad but that works.
3 REPLIES
Community Manager

Re: Oracle ORA-01747

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

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Oracle ORA-01747

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.
One Star

Re: Oracle ORA-01747

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))