DBMS_VECTOR Package Body is invalid due to ORA-942
(Doc ID 3064666.1)
Last updated on FEBRUARY 22, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 23.4 to 23.4 [Release 23]Information in this document applies to any platform.
Symptoms
-- Not able to compile the package body manually:
SQL> alter package sys.dbms_vectory compile body;
Warning: Package Body created with compilation errors.
-- Running the SQL command SQL> show errors gives us the reason DBMS_VECTOR package body is invalid:
SQL> show errors package body sys.dbms_vector
Errors for PACKAGE BODY SYS.DBMS_VECTOR:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1034/7 PL/SQL: SQL Statement ignored
1035/25 PL/SQL: ORA-00942: table or view does not exist
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 |
| Cause |
| Solution |