Discussion in 'SQL PL/SQL' started by bnramesh8, Jun 12, 2014.
What are the methods that are present in save exception?where we can use that methods?
I suppose you mean by "SAVE EXCEPTIONS" clause which is invoked in a "FORALL" DML statement ?
This clause indicates the FORALL to process all the rows even when an error has occurred and "saving" the exceptions that are generated into a pseudo-collection SQL%BULK_EXCEPTIONS.
There is another exceptions clause, when enabling a constraint, to save 'exceptions' into a table named, oddly enough, EXCEPTIONS.