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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center