Hi

i am creating a package body but while creating it i am gettting this error:
" PDE-PUP001 ORA-00604: error occured at recursive sql level 1 "

i had three independent procedures earlier. now i want to keep those 3 procedures in a Package body. i copy the code & pasted in the package body.
out of 3 procedures , codes of 2 procedures were copied and package body was created sucessfully but while i copy the codes of 3rd procedure in the package body it gives me the above mentioned error.

i also tried creating a sql file and then run that file on SQL promt.but again it gives me same error.

early help in this matter is highly appreciated..

thanx