PROCEDURE ODI with 'EXECUTE IMMEDIATE' command
829082Oct 6 2011 — edited Oct 10 2011I'm running an ODI procedure, with the following code:
Begin
for c in (select table_name from sys.all_tables where owner='SYSSTG')
loop
execute immediate ('grant all on SYSSTG.'||c.table_name||' to asoares');
end loop;
End;
I have looked everywhere and can not find the solution, is returning the following error message:
*905 : 42000 : java.sql.SQLException: ORA-00905: missing keyword*
ORA-06512: at line 1+
java.sql.SQLException: ORA-00905: missing keyword+
ORA-06512: at line 1+
* at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)*
* at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)*
* at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)*
* at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)*
* at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)*
* at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)*
* at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)*
* at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)*
* at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)*
* at com.sunopsis.sql.SnpsQuery.executeUpdate(Unknown Source)*
* at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(Unknown Source)*
* at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)*
* at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(Unknown Source)*
* at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)*
* at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)*
* at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)*
* at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(Unknown Source)*
* at com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)*
* at com.sunopsis.dwg.cmd.DwgCmd.k(Unknown Source)*
* at com.sunopsis.dwg.cmd.g.z(Unknown Source)*
* at com.sunopsis.dwg.cmd.DwgCmd.run(Unknown Source)*
* at java.lang.Thread.run(Thread.java:595)*
Can anyone help me?