Re: Delete a Record

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 1 Feb 2002 11:24:16 -0800
Message-ID: <a20d28ee.0202011124.2eee0add@posting.google.com>

"Massimiliano" <melidoro_at_next.fi.it> wrote in message news:<%Uw68.16712$3J1.518271_at_news2.tin.it>...
> I use the WHEN-REMOVE-RECORD trigger to check that the current record
> doesn't affect others record .
> If it doesn't affect any other record I can delete it , in the other case
> no. I try to use abort_query to stop the delete, but the record is always
> deleted.
> What can I try again?

use raise_application_error, this will automatically roll back the statement in error.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 01 2002 - 13:24:16 CST