Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_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.
=20
-----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:=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
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
-- 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-lReceived on Tue Jun 14 2005 - 09:01:20 CDT
![]() |
![]() |