Re: How do I supress ORA error messages in pl/SQL
From: Reinhard Bergander, Oracle Freelancer <reinhard_bergander_at_compuserve.com>
Date: Thu, 19 Nov 1998 00:56:25 -0000
Message-ID: <Om6Cy00E#GA.379_at_nih2naaa.prod2.compuserve.com>
Date: Thu, 19 Nov 1998 00:56:25 -0000
Message-ID: <Om6Cy00E#GA.379_at_nih2naaa.prod2.compuserve.com>
Write your own exception handler:
BEGIN
<your stmts>
EXCEPTION
WHEN OTHERS -- catch all exceptions
THEN
<handle errors>
<display error, e.g. using dbms_output>
END;
Cheers,
Reinhard
Shine Stephen schrieb in Nachricht <72estn$t22_at_masters0.InterNex.Net>...
>Can anybody tell me how to supress oracle default error messages and
display
>my own messages in a pl/sql program
>
>Thanks.
>
>
Received on Thu Nov 19 1998 - 01:56:25 CET