Minimizing Trigger feedback

From: Doug Cowles <dcowles_at_nospambigfoot.com>
Date: Mon, 20 Dec 1999 11:25:19 -0500
Message-ID: <385E586F.6B490B20@nospambigfoot.com>

I was hoping that by using raise_application_error that the amount of messages
returned from Oracle could be minimized. However, the following messages come
up during execution of a very simple trigger (listed below) -

ORA-20001: Piecweight tigger                  (what I was hoping would

be the only message)

ORA-06512: at "schema.garbageproc", line 8
ORA-06512: at "shema.garget", line 2
ORA-04088: error during execution of trigger 'schema.garbage'.

Any way to minimize this?

Here was the code -
create table A (a NUMBER);
create table B( a NUMBER not null);
create or replace procedure garbageproc (newvalue IN NUMBER)
as
begin
insert into B values (newvalue);
exception
when others
  raise_appliction_error(-20001,'PieceWeight trigger'); end;

create or replace trigger garbage
after insert on A
for each row
begin
garbageproc(:new.a);
end;
/

SQL> insert into a values (5);
commit;
SQL> insert into a values (NULL);

The messages above..

Received on Mon Dec 20 1999 - 10:25:19 CST