
Specialist III
2008-12-09
12:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
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 ?
173 Views
2 Replies

Specialist III
2011-10-06
01:29 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !
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 !
173 Views

Anonymous
Not applicable
2011-10-07
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try putting BEGIN/END around your statement in the tOracleRow
173 Views
