ORA-00900 error when trying to execute statement in tOracleRow

One Star

ORA-00900 error when trying to execute statement in tOracleRow

Hi,
I am trying to execute this statement:
"EXEC DBMS_STATS.GATHER_SCHEMA_STATS('my_schema', cascade=>TRUE)"
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.
When I execute this statement in SQLPlus it works fine.
Any idea please ?
One Star

Re: ORA-00900 error when trying to execute statement in tOracleRow

Hello,
I'm trying to do the same, and I've the same problem.
Is it possible to do an "exec dbms_stats" with a Talend job ?
Thx in advance !

Re: ORA-00900 error when trying to execute statement in tOracleRow

try putting BEGIN/END around your statement in the tOracleRow