ORA-00922: missing or invalid option while using tOracleOutputBulkExec

One Star

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
Moderator

Re: ORA-00922: missing or invalid option while using tOracleOutputBulkExec

Hi,
Could you please show us your sql query? Is there any missing  quote in your sql query?
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.