PLS-00907 : cannot load library unit

Hi ,=20

   I have a package and it is invalid.  In the package code , package =
references itself .
   When I tried to compile, I receive following error.

   Do you have any idea.

Rgds.
Arslan.


SQL> alter package CUS$CUST_PRODS_AND_SVCS compile body ;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY CUS$CUST_PRODS_AND_SVCS:

LINE/COL ERROR
-------- =
-----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit =
BC15.CUS$CUST_PRODS_AND_SVCS
         (referenced by BC15.CUS$BR_CUST_PRODS_AND_SVCS)

0/0      PLS-00907: cannot load library unit =
BC15.CUS$CUST_PRODS_AND_SVCS
         (referenced by BC15.CUS$BR_CUST_PRODS_AND_SVCS)

0/0      PLS-00907: cannot load library unit =
BC15.CUS$CUST_PRODS_AND_SVCS
         (referenced by BC15.CUS$BR_CUST_PRODS_AND_SVCS)

62/5     PL/SQL: Statement ignored
304/9    PL/SQL: Statement ignored

LINE/COL ERROR
-------- =
-----------------------------------------------------------------
397/9    PL/SQL: Statement ignored
SQL>=20
--
http://www.freelists.org/webpage/oracle-l

Other related posts: