Re: changing text of error messages

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 12 Sep 2001 17:05:03 +0200
Message-ID: <9nntj1$6jg$1@s1.read.news.oleane.net>

"Mark" <mark_at_c3.be> a écrit dans le message news: edKn7.50707$6x5.10725374_at_afrodite.telenet-ops.be...
> is it possible to change the text of oracle message ( ex ora 0024 )
>
> so that the user can get some more human text ( This is an error ... please
> contact support )
>
> Mark
>

You can get the error message with the sqlerrm function. For instance:

SQL> set serveroutput on
SQL> set feedback off
SQL> exec dbms_output.put_line(sqlerrm(-1));

ORA-00001: unique constraint (.) violated

--
Have a nice day
Michel

Received on Wed Sep 12 2001 - 10:05:03 CDT