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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now