RE: PLS-00907 : cannot load library unit

  • From: <A.Bahar@xxxxxxxxxxxxxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>
  • Date: Tue, 14 Jun 2005 14:26:56 +0200

Please  before to give someone utterly nonsensical advice  and before to pass 
oneself off as a scholar ,  try to read what is said , what is written .  Try 
to understand what is requested . If you don't understand,  If you don't want 
to understand just delete  that email and don't think anymore about it . This 
is the very optimal way for the people like you.
 

 -----Original Message-----
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Monday, June 13, 2005 8:51 PM
To: Bahar, Arslan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: PLS-00907 : cannot load library unit


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  
<mailto: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  
<//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: