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

On Thu, Jan 7, 2010 at 9:40 AM, Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.ny.gov> wrote:
> Rumpi,
>
> The Sqlerrm returns the sql error text.  You can catch the error in a PL/SQL block while you are processing.  Is this what you mean, or are the responses you already received more what you have in mind?
>
>
>  Exception
>     When others
>           L_error_msg := sqlerrm
>
> Tom
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rumpi Gravenstein
> Sent: Thursday, January 07, 2010 8:54 AM
> To: oracle-l-freelists
> Subject: Oracle Function to Return the error text associated with an oracle error code
>
> 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
>
>
>
>
>

-- 
Rumpi Gravenstein
--
http://www.freelists.org/webpage/oracle-l