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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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