Re: Oracle Function to Return the error text associated with an oracle error code
- From: Toon Koppelaars <toon@xxxxxxxxxxx>
- To: rgravens@xxxxxxxxx
- Date: Thu, 7 Jan 2010 15:05:48 +0100
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
> --
> //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:
