PLS-00302: component 'CONDITION_EXISTS' during noncdb_to_pdb.sql execution
(Doc ID 2870321.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
YS@ CTSTNP> declare
2 do_abort boolean := false;
3 begin
4 if dbms_preup.condition_exists ('INVALID_SYS_TABLEDATA') then
5 -- dump out the info
6 dbms_preup.run_check('INVALID_SYS_TABLEDATA');
7 do_abort := TRUE;
8 end if;
9 if dbms_preup.condition_exists ('INVALID_USR_TABLEDATA') THEN
10 -- dump out the info
11 dbms_preup.run_check('INVALID_USR_TABLEDATA');
12 do_abort := TRUE;
13 END IF;
14 If do_abort THEN
15 dbms_output.put_line ('Invalid table data.');
16 dbms_output.put_line ('Non-CDB conversion aborting.');
17 dbms_output.put_line ('For instructions, look for ORA-01722 in this script.');
18 dbms_output.put_line ('Please resolve these and rerun noncdb_to_pdb.sql.');
19 RAISE INVALID_NUMBER;
20 end if;
21 end;
22 /
if dbms_preup.condition_exists ('INVALID_SYS_TABLEDATA') then
*
ERROR at line 4:
ORA-06550: line 4, column 17:
PLS-00302: component 'CONDITION_EXISTS' must be declared
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
ORA-06550: line 9, column 17:
PLS-00302: component 'CONDITION_EXISTS' must be declared
ORA-06550: line 9, column 3:
PL/SQL: Statement ignored
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |