PLS-00907 : cannot load library unit

  • From: <A.Bahar@xxxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Jun 2005 14:52:40 +0200

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: