column names with double Quotes and spaces in a table

Four Stars

column names with double Quotes and spaces in a table

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!

Employee

Re: column names with double Quotes and spaces in a table

Hi,

 

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

 

Warm Regards,

 

Nikhil Thampi

Four Stars

Re: column names with double Quotes and spaces in a table

Hi,
I am using Talend open studio 6.2.1.

Moderator

Re: column names with double Quotes and spaces in a table

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

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: column names with double Quotes and spaces in a table

Hi Sabrina,

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





Moderator

Re: column names with double Quotes and spaces in a table

Hello,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.