Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III

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 ?
Labels (2)
2 Replies
_AnonymousUser
Specialist III
Author

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 !
Anonymous
Not applicable

try putting BEGIN/END around your statement in the tOracleRow