My Oracle Support Banner

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 later
Information 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.