Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Supress a message in forms
Archana reddy via OracleMonster.com wrote:
> I checked
> :system.message_level also
> can you please send me someother solution for that problem
Before this goes any further I'd like to ask the question that popped into my head when I saw your original post.
Why do you want to suppress the message?
It is indicative of something that should be dealt with by fixing the problem not hiding the message.
DECLARE
i PLS_INTEGER := 0;
BEGIN
i := 1/i;
EXCEPTIONS
WHEN OTHERS THEN
NULL;
END;
/
Works really well too but would you really want it in your code?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond) ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =---Received on Thu Jan 20 2005 - 01:20:03 CST