https://community.qlik.com/t5/Talend-Studio/ORA-00900-error-when-trying-to-execute-statement-in-tOracleRow/m-p/2281386#M55929 Hello,<BR />I'm trying to do the same, and I've the same problem.<BR />Is it possible to do an "exec dbms_stats" with a Talend job ?<BR />Thx in advance ! Thu, 06 Oct 2011 17:29:03 GMT _AnonymousUser 2011-10-06T17:29:03Z https://community.qlik.com/t5/Talend-Studio/ORA-00900-error-when-trying-to-execute-statement-in-tOracleRow/m-p/2281385#M55928 Hi,<BR />I am trying to execute this statement:<BR />"EXEC DBMS_STATS.GATHER_SCHEMA_STATS('my_schema', cascade=&gt;TRUE)"<BR />with a tOracleRow but I get the error ORA-00900: invalid SQL Statement. It's the same with a ; at the end of the line.<BR />When I execute this statement in SQLPlus it works fine.<BR />Any idea please ? Sat, 16 Nov 2024 14:07:47 GMT https://community.qlik.com/t5/Talend-Studio/ORA-00900-error-when-trying-to-execute-statement-in-tOracleRow/m-p/2281385#M55928 _AnonymousUser 2024-11-16T14:07:47Z https://community.qlik.com/t5/Talend-Studio/ORA-00900-error-when-trying-to-execute-statement-in-tOracleRow/m-p/2281386#M55929 Hello,<BR />I'm trying to do the same, and I've the same problem.<BR />Is it possible to do an "exec dbms_stats" with a Talend job ?<BR />Thx in advance ! Thu, 06 Oct 2011 17:29:03 GMT https://community.qlik.com/t5/Talend-Studio/ORA-00900-error-when-trying-to-execute-statement-in-tOracleRow/m-p/2281386#M55929 _AnonymousUser 2011-10-06T17:29:03Z https://community.qlik.com/t5/Talend-Studio/ORA-00900-error-when-trying-to-execute-statement-in-tOracleRow/m-p/2281387#M55930 try putting BEGIN/END around your statement in the tOracleRow Fri, 07 Oct 2011 15:35:14 GMT https://community.qlik.com/t5/Talend-Studio/ORA-00900-error-when-trying-to-execute-statement-in-tOracleRow/m-p/2281387#M55930 Anonymous 2011-10-07T15:35:14Z