Hello,
I created a bunch of public synonyms and got the object package body invalid for the SYSTEM owner
| SYS | PACKAGE | VALID |
| SYS | PACKAGE BODY | VALID |
| SYSTEM | PACKAGE | VALID |
| SYSTEM | PACKAGE BODY | INVALID |
I get these errors when trying to use another user than SYS:
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level
I have made the below in order to correct the errors
recreated DBMS_APPLICATION_INFO
1. dbmsapin.sql
2. prvtapin.plb
recreated DBMS_OUTPUT:
1. dbmsotpt.sql
2. prvtotpt.plb
exec DBMS_APPLICATION_INFO.SET_MODULE('SQL*plus', 'Testing DBMS_APPLICATION_INFO');
exec DBMS_OUTPUT.DISABLE;
After that it errors no longer appear but I am still seeing the Package Body invalid.
| SYS | PACKAGE | VALID |
| SYS | PACKAGE BODY | VALID |
| SYSTEM | PACKAGE | VALID |
| SYSTEM | PACKAGE BODY | INVALID |
DB: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
Please advise,
Regards,
Daniel