OraFAQ Forum: SQL & PL/SQL » Re: want to stop the insert/delete/update transaction in an AFTER TRIGGER

Home » SQL & PL/SQL » SQL & PL/SQL » Re: want to stop the insert/delete/update transaction in an AFTER TRIGGER

Wed, 28 August 2002 12:54

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

To abort the DML, just raise an error:

if not some_condition then
  raise_application_error(-20000, 'Invalid item transaction');
end if;

Previous Topic:	Date format DD-MON-YYYY
Next Topic:	oracle cursors not working well

Goto Forum:

]

Current Time: Fri Apr 26 12:02:17 CDT 2024