RE: PLS-00907 : cannot load library unit

  • From: Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>
  • To: "'A.Bahar@xxxxxxxxxxxxxxxxxxxxxx'" <A.Bahar@xxxxxxxxxxxxxxxxxxxxxx>, <jkstill@xxxxxxxxx>
  • Date: Tue, 14 Jun 2005 09:55:52 -0400

What Jared said was correct.  You jumped to conclusion too soon.  The advise of 
some members (some of them are Authors) of this list is invaluable.  To my 
knowledge, Jared never insulted anyone.....you owe him apology.

Muqthar
Oracle9i Certified DBA

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of A.Bahar@xxxxxxxxxxxxxxxxxxxxxx
Sent: Tuesday, June 14, 2005 8:27 AM
To: jkstill@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: PLS-00907 : cannot load library unit


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

* * * * * * * * *

The information contained in this E-mail message is privileged, confidential, 
and may be protected from disclosure; please be aware that any other use, 
printing, copying, disclosure or dissemination 
of this communication may be subject to legal restriction or sanction. If you 
think that you have received this E-mail message in error, please reply to the 
sender and delete it from your computer. T
hank you.
--
//www.freelists.org/webpage/oracle-l

Other related posts: