Logged into a RAC database as user with DBA privileges. When altering a job owned by another schema, which has been scheduled to run on a specific instance, the following error is displayed:
"ORA-06550 - line 12, col 6
PLS00103 - encountered the symbol "," when expecting one of the following ..."
On clicking the 'Show SQL' button the following SQL statement is displayed:
BEGIN
SYS.DBMS_IJOB.WHAT
(job => 101
,what => 'schemaname.procedure'
(1);');
SYS.DBMS_IJOB.NEXT_DATE
(job => 101
,next_date => NEXT_DAY(TRUNC(SYSDATE), 'SUNDAY'));
SYS.DBMS_IJOB.INTERVAL
(job => 101
,interval => 'NEXT_DAY(TRUNC(SYSDATE), ''SUNDAY'')'); **
,instance => 4
,force => TRUE
END;
** Note the ';' after the 'interval' argument, which is then followed by two additional arguments
WORKAROUND:
In the the 'Alter Job' window, set the 'Instance' to zero
STATUS:
Waiting for fix in a future release of Toad for Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center