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

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

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