Re: Oracle Function to Return the error text associated with an oracle error code

SQL> set serveroutput on
SQL> l
  1  declare v varchar2(2000);
  2  begin
  3    v := sqlerrm(-1);
  4    dbms_output.put_line(v);
  5* end;
SQL> /
ORA-00001: unique constraint (.) violated

PL/SQL procedure successfully completed.

SQL>

On Thu, Jan 7, 2010 at 2:53 PM, Rumpi Gravenstein <rgravens@xxxxxxxxx>wrote:

> All,
>
> Is there an Oracle function that will return the Oracle error text
> associated with a particular Oracle error.  I know there are web
> sites, and OS procedures that do this but have never seen one that can
> be called from SQL .  Does such a function exist?
>
> --
> Rumpi Gravenstein
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Toon Koppelaars
RuleGen BV
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13

Other related posts: