Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PLS-00907 : cannot load library unit

RE: PLS-00907 : cannot load library unit

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Tue, 14 Jun 2005 09:55:52 -0400
Message-ID: <6362087FB073D41195B800D0B78284BE09814733@mail01.corp.abwf.com>


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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A.Bahar_at_billing-components.com Sent: Tuesday, June 14, 2005 8:27 AM
To: jkstill_at_gmail.com
Cc: oracle-l_at_freelists.org
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_at_gmail.com] Sent: Monday, June 13, 2005 8:51 PM
To: Bahar, Arslan
Cc: oracle-l_at_freelists.org
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_at_billing-components.com < A.Bahar_at_billing-components.com <mailto:A.Bahar_at_billing-components.com> > 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
--

http://www.freelists.org/webpage/oracle-l <http://www.freelists.org/webpage/oracle-l>

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--

http://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.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 14 2005 - 10:00:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US