EXIT or RETURN in Stored Procedures
390534Jan 14 2005 — edited Jan 14 2005Anyone,
Should I use EXIT/RETURN/GOTO when in a stored procedure and I am trying to deal with EXCEPTION handling but need to exit out of stored proc handing back a value in an OUT variable to the calling procedure?
I have been working with all three and I still seem to have a memory leak that causes a
"ORA-03113: end-of-file on communication channel"
Error after running the same procedures several times. I think this is related to the way I am exiting the procedure and the fact that I am in nested CURSORS.
Any help would be greatly appreciated.
Thanks,
Miller