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.
Could you please let us know if this solution mentioned in jira issue is OK with you?
Here exists a related topic:https://community.talend.com/t5/Design-and-Development/resolved-special-characters-in-oracle-column-...
This Oracle error is generated on field names which are reserved words. Those needs to be enclosed in double quotes.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
View this on-demand webinar about APIs....
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Learn how and why companies are moving to the Cloud