In oracle,Usually when we use forall save exceptions to capture error occurring records through bulk load, we will use for loop to iterate the SQL%bulk exceptions and capture the error records..there is a requirement to use while loop instead of for loop in exception block to capture SQL%bulk exceptions. Please could someone post working code on how to use while loop for capturing SQL%bulk exceptions?
i tried with for loop to capture SQL%bulk exceptions with error code and error index. But need to kno, how to use while loop to achieve this
Narasimhan M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.