Oracle: recompile a PL/SQL package
August 20, 2009 04:03:07 Last update: August 20, 2009 04:03:07
Use alter package to recompile a PL/SQL package.
SQL> alter package UTIL compile;
Warning: Package altered with compilation errors.
SQL> show errors;
Errors for PACKAGE UTIL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
106/3 PL/SQL: Declaration ignored
106/29 PLS-00201: identifier 'ID_TYPE' must be declared
SQL>
SQL>
SQL> select line, position, text from user_errors where name = 'UTIL' order by line;
LINE POSITION
---------- ----------
TEXT
--------------------------------------------------------------------------------
106 3
PL/SQL: Declaration ignored
106 29
PLS-00201: identifier 'ID_TYPE' must be declared
SQL>
Easy email testing with http://www.ximailstop.com