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