RE: PLS-00907 : cannot load library unit

 But Jared was correct in that you did not list the version of Oracle or
provide the package code.  Nor did you identify if the package was home
grown or part of a vendor product.  The package in question is not a
standard Oracle package so those items should have been part of your
post.  You did list the errors which is more than quite a few posters
have done, but it isn't enough to get proper, well reasoned responses.

Is CUS$CUST_PRODS_AND_SVCS a part of Oracle Applications?  Is so there
is an Oracle Applications board on metalink that may be of help.

IMHO -- Mark D Powell --


-----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.
=20

 -----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:=20

Hi ,=3D20

   I have a package and it is invalid.  In the package code , package =
=3D
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.=20

SQL> show errors
Errors for PACKAGE BODY CUS$CUST_PRODS_AND_SVCS:

LINE/COL ERROR
-------- =3D
-----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit =3D=20
BC15.CUS$CUST_PRODS_AND_SVCS
         (referenced by BC15.CUS$BR_CUST_PRODS_AND_SVCS)

0/0      PLS-00907: cannot load library unit =3D
BC15.CUS$CUST_PRODS_AND_SVCS
         (referenced by BC15.CUS$BR_CUST_PRODS_AND_SVCS )

0/0      PLS-00907: cannot load library unit =3D
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=20

LINE/COL ERROR
-------- =3D
-----------------------------------------------------------------
397/9    PL/SQL: Statement ignored
SQL>=3D20
--
http://www.freelists.org/webpage/oracle-l
<http://www.freelists.org/webpage/oracle-l>=20





--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist




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

Other related posts: