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

You can create a SAVEPOINT before the i/u/d statement, then ROLLBACK to the SAVEPOINT if an exception is raised. Hope this helps. Paul

In article <81ngti$abq$1_at_nnrp1.deja.com>,   M. Armaghan Saqib <armaghan_at_yahoo.com> wrote:
> Hi,
>
> How can we cancel ins/upd/del of ALL rows in a stmt if an exception
for
> 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.

> * 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.

>



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