Re: PLS-00907 : cannot load library unit

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: A.Bahar@xxxxxxxxxxxxxxxxxxxxxx
  • Date: Mon, 13 Jun 2005 19:51:00 +0100

Aside from failing to mention database version and platform, or 
including a sample of the code that causes the problem,
it also appears that you have neither googled nor checked MetaLink.
Please also read http://www.catb.org/~esr/faqs/smart-questions.html

Jared


On 6/13/05, A.Bahar@xxxxxxxxxxxxxxxxxxxxxx <A.Bahar@xxxxxxxxxxxxxxxxxxxxxx> 
wrote:
> 
> 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
> --
> //www.freelists.org/webpage/oracle-l
> 



-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
//www.freelists.org/webpage/oracle-l

Other related posts: