how to capture exception in cursors
Hi,
I wnated to bulk collect say 100 record into global temporaary table,suppose if there is a exception in any of the record how could i handle it?
for example 2 records are throwing exception in this case i want remaining 98 to get processed and remaining 2 should be captured in the exception block.
Please share your suggestion