DBMS_SODA_ADMIN DBMS_SODA_DML INVALID RESULTING IN XDB COMPONENT TO BE ALSO INVALID (Doc ID 2974481.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

-- The following objects are invalid:

OWNER OBJECT_TYPE OBJECT_NAME STATUS
------------------------------ ------------------------------ ------------------------------ ---------------
XDB PACKAGE BODY DBMS_SODA_ADMIN INVALID
XDB PACKAGE BODY DBMS_SODA_DML INVALID

--Attempting to compile the objects results in the following:

SQL> ALTER PACKAGE XDB.DBMS_SODA_ADMIN COMPILE BODY;
Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY XDB.DBMS_SODA_ADMIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
254/7 PL/SQL: SQL Statement ignored
256/18 PL/SQL: ORA-00942: table or view does not exist
261/7 PL/SQL: SQL Statement ignored
263/18 PL/SQL: ORA-00942: table or view does not exist
278/5 PL/SQL: SQL Statement ignored
280/16 PL/SQL: ORA-00942: table or view does not exist
964/5 PL/SQL: SQL Statement ignored
974/16 PL/SQL: ORA-00942: table or view does not exist

SQL>ALTER PACKAGE XDB.DBMS_SODA_DML COMPILE BODY;
Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY XDB.DBMS_SODA_DML:

LINE/COL ERROR
-------- -----------------------------------------------------------------
12/5 PL/SQL: SQL Statement ignored
12/21 PL/SQL: ORA-00942: table or view does not exist
24/5 PL/SQL: SQL Statement ignored
25/16 PL/SQL: ORA-00942: table or view does not exist
34/5 PL/SQL: SQL Statement ignored
34/16 PL/SQL: ORA-00942: table or view does not exist

Cause

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