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