Is it possible to do an "exec dbms_stats" with a Talend job ?
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/TOAD it works fine.
I'm on Oracle 11g, and Talend 4.0.3.
Any idea please ?
Thx in advance !
Sorry for my english..