DBMS_SQLPA – PACKAGE BODY – INVALID 10g
March 5, 2014 Leave a comment
To resolve the issue, do the following:
1. Connect as SYSDBA
$ sqlplus / as sysdba
2. Drop plan table
SQL> drop table plan_table;
Table dropped.
3. Recreate plan table
SQL> @?/rdbms/admin/utlxplan
Table created.
4. Re-create dbms_sqlpa package and public synonym
SQL> @?/rdbms/admin/prvtspao.plb
PL/SQL procedure successfully completed.
Package created.
No errors.
Synonym created.
No errors.
Package body created.
No errors.
5. Recompile all objects
SQL> @?/rdbms/admin/utlrp.sql
DBA Knowledge Base 