Re: PLS-00907 : cannot load library unit

From: rachel carmichael <wisernet100_at_gmail.com>
Date: Tue, 14 Jun 2005 09:39:40 -0400
Message-ID: <2e7118730506140639583a8fb0@mail.gmail.com>

In what way did Jared give "utterly nonsensical advice" and try to pass himself off as a scholar?

it would appear you did not read what he wrote.

PL/SQL is notorious for reporting an error line that is not actually the line in error, but is the one where the error from lines above is first caught.

Without seeing your script, without knowing what version of Oracle you are running and on what platform, it is hard for us to diagnose your problem.

You are asking this list to perform brain surgery blindfolded. When we tell you we need the blindfold removed, you castigate us.

If you wish us to help you, it might be smarter to be polite about it.

Now... if you would like to post the actual code, the version of Oracle and the platform you are running on, perhaps one of us could help you resolve your problem.

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 ab=

out it . This is the very optimal way for the people like you.

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

>=20
>=20

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

>=20

> Please also read http://www.catb.org/~esr/faqs/smart-questions.html

>=20

> Jared

>=20
>=20
>=20

> On 6/13/05, A.Bahar_at_billing-components.com < A.Bahar_at_billing-components.c=
om <mailto:A.Bahar_at_billing-components.com> > wrote:

>=20

> Hi ,=3D20

>=20

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

>=20

> Do you have any idea.

>=20

> Rgds.
> Arslan.

>=20
>=20

> SQL> alter package CUS$CUST_PRODS_AND_SVCS compile body ;

>=20

> Warning: Package Body altered with compilation errors.

>=20

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

>=20

> 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)

>=20


> 0/0      PLS-00907: cannot load library unit =3D

> BC15.CUS$CUST_PRODS_AND_SVCS

>          (referenced by BC15.CUS$BR_CUST_PRODS_AND_SVCS )

>=20


> 0/0      PLS-00907: cannot load library unit =3D

> BC15.CUS$CUST_PRODS_AND_SVCS

>          (referenced by BC15.CUS$BR_CUST_PRODS_AND_SVCS)

>=20


> 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/webp=
age/oracle-l>

>=20
>=20
>=20
>=20
>=20

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

>=20
>=20
>=20
>=20

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

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

Received on Tue Jun 14 2005 - 09:44:46 CDT