Compile

alter package INV.INV_TRANSFER_ORDER_PVT compile;

Check error if any

show error;

C:\Documents and Settings\ptian>sqlplus apps/password@instance

SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 7月 16 23:57:18 2012

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter package INV.INV_TRANSFER_ORDER_PVT compile;

Warning: Package altered with compilation errors.

SQL> show error;
Errors for PACKAGE INV.INV_TRANSFER_ORDER_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
67/3     PL/SQL: Declaration ignored
72/70    PLS-00201: identifier \'INV_GLOBALS.G_MISS_CONTROL_REC\' must be
         declared

103/3    PL/SQL: Declaration ignored
109/76   PLS-00201: identifier \'INV_MOVE_ORDER_PUB.G_MISS_TROHDR_REC\'
         must be declared

SQL>

转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7753545

===EOF===

ITPub博客

Compile Invalid Package/Package Body,and check the error if any

最新文章