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.