https://community.qlik.com/t5/Talend-Studio/ORA-00922-missing-or-invalid-option-while-using/m-p/2241789#M28836 Hi,<BR />Could you please show us your sql query? Is there any missing &nbsp;quote in your sql query?<BR />Best regards<BR />Sabrina Tue, 03 Mar 2015 09:24:46 GMT Anonymous 2015-03-03T09:24:46Z https://community.qlik.com/t5/Talend-Studio/ORA-00922-missing-or-invalid-option-while-using/m-p/2241788#M28835 Hello All,<BR />I created a job to load the data from MYSQL to Oracle by using Target output component is &nbsp;&nbsp;tOracleOutputBulkExec. But I am getting the below error:<BR />java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option<BR />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):<BR />--&gt;Use schema's Date pattern to load date field<BR />--&gt;Convert columns and table to Uppercase<BR />Could you please anyone help me to fix this issue<BR />Thanks and Regards,<BR />Sridevi Mon, 02 Mar 2015 14:47:16 GMT https://community.qlik.com/t5/Talend-Studio/ORA-00922-missing-or-invalid-option-while-using/m-p/2241788#M28835 Anonymous 2015-03-02T14:47:16Z https://community.qlik.com/t5/Talend-Studio/ORA-00922-missing-or-invalid-option-while-using/m-p/2241789#M28836 Hi,<BR />Could you please show us your sql query? Is there any missing &nbsp;quote in your sql query?<BR />Best regards<BR />Sabrina Tue, 03 Mar 2015 09:24:46 GMT https://community.qlik.com/t5/Talend-Studio/ORA-00922-missing-or-invalid-option-while-using/m-p/2241789#M28836 Anonymous 2015-03-03T09:24:46Z