Hi Ketan,<br><br>You can try to use autonomous transaction (a new feature of 8i). All you have to do is to add a PRAGMA AUTONOMOUS_TRANSACTION in your procedure:<br><br>CREATE PROCEDURE ... AS PRAGMA AUTONOMOUS_TRANSACTION;<br>BEGIN<br> ...<br>END;<br><br>You only have to know that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.