How can we cancel ins/upd/del of ALL rows in a stmt if an exception for some rows is raised during stmt?

How can we cancel ins/upd/del of ALL rows in a stmt if an exception for [Quoted] [Quoted] some rows is raised during stmt execution?

That is, I do not want to ins/upd/del any single row if all intended rows are not processed during a stmt.

This is required because I want to do some processing in AFTER-STMT trigger which does not get executed in this case.

Even a small hint will be helpful.

thanks in advance and regards,

--
------------------------------------------------------------------------


* SQL PlusPlus: Add power to SQL Plus.

* SQL Link for XL: Integrate Oracle with XL.


[Quoted] [Quoted] * Oracle CBT with sample GL (Triggers and Forms Source Code included.


Download FREE ALL
--
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.