-
recursive SQL error
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
-
-
i am just putting all the three independant procedures in one package.
the procedures are doing fine independantly but when i am copying the code from those procedures (by simple cut,copy & paste command) inside the package, its giving me error.
thanx in advance
-
As Tamil said "post the code" of both your header and your body package.
If you are doing copy/paste you are probably not following the appropriate syntax to build a package.
-
i am able to create two procedures inside the package body. the error is coming only when i paste third proc. even in that third proc i am able to paste 500 lines of code (out of total 1000 lines ). the error comes only when i paste rest of the code...... so that means third procedure is also created but only half of the code exits in the proc...syntax & everything is ok since it is not giving any compilation error to me....only when i paste rest of the 500 lines of code it gives me the error...
-
is there anyone in this forum who can help me and sort my problem out.
-
I see... you are not posting your code no matter how many times you are asked to do it.
Would you at least copy/paste -as opposed to typing it in- the whole error stack?
-
did you miss the part where you were asked to post the code?
-
binoyshil:
If you're not comfortable posting your real code- due to security reason(s), create a pl/sql generic package code that would show the viewers exactly what you're requesting help for. This way, the viewers would understand your issue(s) as to render the necessary help.
DSupp2008.