Q: Triggers and raise_application_error

I am trying to remove any additional errors that are being produced when I run the exception handling.

...

if (condition) then

        raise my_error;
end if;
...

exception

when my_error then

        raise_application(-20001, ' My Error.');
....

and this seems to work EXCEPT I get the following additional errors when I insert into the table.

ORA-20001: My Error.                 << This is EXCELLENT
ORA-06512: at line 18	             << I DO NOT WANT to see this

Is there any way to handle the remaining two errors within my exception routine?

regards
tony
tony_at_isotro.com Received on Mon Oct 07 1996 - 00:00:00 CEST