Re: Error produced when trigger do raise_application_error

Karsten Farell wrote:
> What you need to do is handle the ORA errors on the client side in an
> EXCEPTION block, where you display the error message passed to
> RAISE_APPLICATION_ERROR. For example:
>
> DECLARE
> unable_to_delete exception;
> pragma exception_init (unable_to_delete, -20001);
> BEGIN
> ...
> EXCEPTION
> when unable_to_delete then
> dbms_output.put_line(sqlerrm);
> END;
>

Hit the Send too fast. Also need this in the EXCEPTION block to get rid of the ORA messages:

EXCEPTION
   when others then null; Received on Thu Oct 10 2002 - 18:05:05 CDT