Re: How do I supress Oracle Error Messages from being dispalyed from a PL?SQL progm

You need to trap your own exceptions if you want to print out your own messages. I would refer to your pl/sql docs for detailed instructions.

First you declare an exception in your pl/sql block's declare section, then you perform your own error checking and RAISE the exception when necessary. Then at the end of your block you have an EXCEPTION section where you print out your error message. You can also alias your own error messages for standard Oracle error codes using the PRAGMA EXCEPTION_INIT clause when declaring an exception. See your docs for more info... If you haven't picked it up, O'Reilly's "Programming with PL/SQL" is a great introduction and manual for pl/sql.

--Manish Nag
(mnag_at_geocities.com)

Shine Stephen wrote in message <72es8e$ra4_at_masters0.InterNex.Net>...
>How do I supress Default Oracle error messages from displayed from a PL/SQL
>program. For eg: I want to print out my own error message instead of oracle
>error message.
>
>Thanks,
>
>
>
Received on Thu Nov 12 1998 - 09:28:39 CST