Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ORA-00922: missing or invalid option while using tOracleOutputBulkExec

Hello All,
I created a job to load the data from MYSQL to Oracle by using Target output component is   tOracleOutputBulkExec. But I am getting the below error:
java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option
If I use tlogrow it is printing the data on the console. I have checked the below options also which are available for toracle bulk component (Advanced settings):
-->Use schema's Date pattern to load date field
-->Convert columns and table to Uppercase
Could you please anyone help me to fix this issue
Thanks and Regards,
Sridevi
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi,
Could you please show us your sql query? Is there any missing  quote in your sql query?
Best regards
Sabrina