| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PLS-00907 : cannot load library unit
I'm afraid I agree with Rafiq. The answer Jared provided is proper,
although I can see that someone not familiar with the ways of the list
would see it as offensive. The idea is to do as much as one can on
one's own before posting a question to the list. Checking the manuals
and Metalink are first steps. A simple check of the error messages
manual would have provided the following:
Error: PLS-907
Text: cannot load library unit %s (referenced by %s)
------------------------------------------------------------------------
---
Cause: PL/SQL is unable to find and load a library unit that was
previously available. This typically happens when you try to
load a unit which references another library unit that is
non-existent or invalid.
Action: Provide the needed library unit.
But much beyond that no one here can do much to help without the version, operating system and version, and the code. And on top of that I think that the pl/sql compiler is really trying to tell you something, especially at:
62/5 PL/SQL: Statement ignored 304/9 PL/SQL: Statement ignored 397/9 PL/SQL: Statement ignored
That's lines 62, 304, and 397. There's something there that is wrong which is causing the package to not compile creating the other errors.
Suggestion, use the following SQL:
Select line, text from user_source
where type = upper('&object_type')
and name = upper('&object_name')
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mohammad Rafiq
Sent: Saturday, June 18, 2005 6:05 PM
To: A.Bahar_at_billing-components.com
Cc: jkstill_at_gmail.com; oracle-l_at_freelists.org
Subject: Re: PLS-00907 : cannot load library unit
A.Bahar,
Your response is totally un professional and insulting not to Jared but for every one on this list who are helping others.
Jared's advise was totally correct as the requester did not try even on google( a free source) or metalink or even did not give basic info about database or that package.
I sincerly hope that you will avoid such tone in future as most of list members are very senior in experience and very valued due to their contributions towards this list for last several years.
Regards
Rafiq
On 6/14/05, A.Bahar_at_billing-components.com
<A.Bahar_at_billing-components.com> wrote:
> 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
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jun 18 2005 - 18:37:49 CDT
 |
 |