QUESTION: raise_application_error results in ORA-00604...?

From: BD <bobby_dread_at_hotmail.com>
Date: 24 May 2006 14:51:43 -0700
Message-ID: <1148507503.607552.58670@38g2000cwa.googlegroups.com>

Hey, all.

I've seen a few postings on this, but am not entirely clear if there's anything I can do about it.

I have created a trigger which will prevent logon under certain specific conditions.

The direct means of preventing logon is being done via a raise_application_error (-20001, "Sorry - access denied") kind of scenario.

What I'd hoped for was that the user would only see the "ORA-20001: Sorry - access denied" error, but as well, they see

ORA-00604: error occurred at recursive SQL level 1
ORA-20001: Sorry, access denied
ORA-06512: at line 19

It's not a huge deal if they see the 00604 and the 06512, but my preference would be that they don't. Anyone know of a way to limit the error messages that the user sees? Maybe something I can do with serveroutput??

Thanks!!

BD Received on Wed May 24 2006 - 16:51:43 CDT