I have a Java webapp with an Oracle DB, and I try to execute this statement at the end of a data migration script:
EXEC DBMS_STATS.GATHER_TABLE_STATS (ownname => 'MY_SCHEMA', tabname => 'MY_TABLE', estimate_percent => dbms_stats.auto_sample_size);
It works in sql*plus, but not via JDBC:
"Error: ORA-00900: invalid SQL statement"
What am I doing wrong?