RE: PLS-00907 : cannot load library unit

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <rafiq9857@xxxxxxxxx>, <A.Bahar@xxxxxxxxxxxxxxxxxxxxxx>
  • Date: Sat, 18 Jun 2005 18:31:31 -0400

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')
  and line between &line-5 and &line+5
order by line;

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mohammad Rafiq
Sent: Saturday, June 18, 2005 6:05 PM
To: A.Bahar@xxxxxxxxxxxxxxxxxxxxxx
Cc: jkstill@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxx
<A.Bahar@xxxxxxxxxxxxxxxxxxxxxx> 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@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
> --
> 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-l

Other related posts: