I am facing a problem. I have a interface procedure having arround 200 sql staement. Inserting all the returning value of sql in a table. So it will insert 200 rows in the table.
I am handling the exception through Savepoint. But the problem is that suppose i will get a exception after executing 60 sql stmt, then the proc is inserting 59 rows in table and i want to continue the excecution up to 200 stmt.
Can anybody explain me how i can continue the execution after getting the exception.(Without using New Block Begin ... End)