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

On 24 May 2006 14:51:43 -0700, "BD" <bobby_dread_at_hotmail.com> wrote:

>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

IIRC a simple exception section with a single dbms_output.put_line message is sufficient.
The trigger *has* to fail or you won't be disconnected.

--
Sybrand Bakker, Senior Oracle DBA