My Oracle Support Banner

ORA-65040: operation not allowed from within a pluggable database when trying: drop procedure sys.VALIDATE_APEX (Doc ID 2767876.1)

Last updated on APRIL 10, 2021

Applies to:

Oracle Application Express (APEX) - Version 4.2 and later
Information in this document applies to any platform.

Symptoms

 ==>> On the PDB

SQL> drop procedure sys.VALIDATE_APEX;
drop procedure sys.VALIDATE_APEX
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database


===>> On the CDB he confirmed the package do NOT exist
SQL> sho con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> DROP PROCEDURE VALIDATE_APEX;
DROP PROCEDURE VALIDATE_APEX

*
ERROR at line 1:
ORA-04043: object VALIDATE_APEX does not exist

Changes

 Removed APEX from the CDB and this package was found left behind in PDB only

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.