Re: PLS-00907 : cannot load library unit

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@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 ab=
out it . This is the very optimal way for the people like you.
>=20
>=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
>=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@xxxxxxxxxxxxxxxxxxxxxx < A.Bahar@xxxxxxxxxxxxxxxxxxxx=
om  <mailto:A.Bahar@xxxxxxxxxxxxxxxxxxxxxx> > 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

Other related posts: