raise_application_error with Triggers

From: Rishaal Jadoo <rischalj_at_dp.new.iscorltd.co.za>
Date: Mon, 25 May 1998 09:18:30 -0700
Message-ID: <356999D5.B1555A06@dp.new.iscorltd.co.za>

Hi,
I have raised an application error from inside the PL/SQL block section of a CREATE TRIGGER statement. The user error is raised successfully, but in addition to that, there are two other errors which are raised. The statement which is used in the PL/SQL block is :-

raise_application_error(-20000,'Invalid data')

The trigger is fired under the correct conditions i.e when the relevant actions on the database are performed, but the following errors are raised :-

ERROR at line 1:

ORA-20000: Invalid data {Which seems correct}
ORA-06512: at <Trigger Name>, line 9 {Why does it do this ?}
ORA-04088: error during execution of trigger <Trigger Name> {Why does it

do this ?}

Thanks. Received on Mon May 25 1998 - 11:18:30 CDT