Oracle: recompile a PL/SQL package 

Joined:
04/09/2007
Posts:
703

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>
Share |
| Comment  | Tags
 
Easy email testing with http://www.ximailstop.com