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

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I supress Oracle Error Messages from being dispalyed from a PL?SQL progm

From: Shine Stephen <sinasu_at_hotmail.com>
Date: Fri, 13 Nov 1998 15:04:18 -0500
Message-ID: <72i3qk$sif@masters0.InterNex.Net>

But those triggers are form level. I want something to put in a database level in the Unix box.

Thanks.

>Each Oracle default message have a number. One way to print your own
messages
>is to create two triggers, on-error and on-message, at the form level.
>Whenever a message is generated by oracle it will cause one of these
triggers
>to fire. You can then call a message routine from these triggers by passing
>the message number to the routine. In the on-message trigger the message
>number is in message_code and in on-error it is in error_code. You can then
>check the message number in the routine and then display you customized
>message. Good luck.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Nov 13 1998 - 14:04:18 CST