topic Oracle ORA-01747 in Talend Studio

Oracle ORA-01747

Anonymous — Sat, 16 Nov 2024 13:51:28 GMT

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.

Re: Oracle ORA-01747

Anonymous — Fri, 24 Jul 2009 08:55:12 GMT

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

shong

Re: Oracle ORA-01747

Anonymous — Fri, 24 Jul 2009 08:56:49 GMT

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.

Re: Oracle ORA-01747

Anonymous — Fri, 24 Jul 2009 08:59:38 GMT

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