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> 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 > -- > //www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l