Christine_Chavez_6412

What are the supported Oracle SQL commands that you can use in an SQL Job?

Discussion created by Christine_Chavez_6412 on Aug 4, 2016
Latest reply on Jan 19, 2017 by Christine_Chavez_6412
Hello,

I'm able to run the following (Process tab) successfully:

SQL_SET_STATEMENT_TERMINATOR TERM='/'; 
BEGIN 
UC_REORG('MQCP001'); 
UC_REORG('MQCP002'); 
END; 


But if I add either a WHENEVER SQLERROR EXIT 2 or ALTER TABLE... command, it fails with an ORA error of Invalid SQL statement.

Does anybody have a list of Oracle SQL commands that are supported/not supported in a SQL job?

Thanks!

Outcomes