column names with double Quotes and spaces in a table

[Anonymous]

Hi,

I am trying to insert data in table through tOracleOutput  having column names with double Quotes and spaces (Like "ABC DE"
). I am getting an error -"ABC DE": invalid identifier. 

Can anyone help me in getting this error fix.

Thank you!

[Anonymous]

Hi,

    Could you please share the version of Talend you are using?

Warm Regards,

Nikhil Thampi

[Anonymous]

Hi,
I am using Talend open studio 6.2.1.

[Anonymous]

Hello,

Could you please let us know if this solution mentioned in jira issue is OK with you?

https://jira.talendforge.org/browse/TDI-19603

This issue has been fixed on 4.2.5, 5.0.3, 5.1.0M1

Here exists a related topic:https://community.talend.com/t5/Design-and-Development/resolved-special-characters-in-oracle-column-...

Best regards

Sabrina

 

[Anonymous]

Hi Sabrina,

I looked into these solutions but it's not working on my case.

[Anonymous]

Hello,

This Oracle error is generated on field names which are reserved words. Those needs to be enclosed in double quotes.

Best regards

Sabrina