Using the My Oracle Support Portal (MOSC)

MOSC Banner

Unable to create DBMS.JOB after upgrading from 12c to 19c database

SQL> BEGIN

 2  DBMS_SCHEDULER.CREATE_JOB

 3  (

 4   JOB_NAME      => 'AS_FOLYAMAT_MEGSZAKITAS'

 5  , PROGRAM_NAME    => 'AS_FOLYAMAT_MEGSZAKIT'

 6  , EVENT_CONDITION   => 'TAB.USER_DATA.MESSAGE = ''FOLYAMAT_MEGSZAKITAS'''

 7  , QUEUE_SPEC     => 'AS_QUEUE'

 8  , ENABLED       => TRUE

 9  );

 10

 11  $IF DBMS_DB_VERSION.VER_LE_10 $THEN

 12   NULL;

 13  $ELSE

 14   DBMS_SCHEDULER.SET_ATTRIBUTE

 15   (

 16    NAME      => 'AS_FOLYAMAT_MEGSZAKITAS'

 17   , ATTRIBUTE    => 'PARALLEL_INSTANCES'

 18   , VALUE      => TRUE

 19   );

 20  $END

 21 END;

 22 /

BEGIN

*

ERROR at line 1:

ORA-00904: "SYS"."SCHEDULER$_QP_1651201"."F3": invalid identifier

ORA-06512: at "SYS.DBMS_ISCHED", line 175

ORA-06512: at "SYS.DBMS_SCHEDULER", line 536

ORA-06512: at line 2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center