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

Yes and thank you all.  I was looking for the sqlerrm function.

On Thu, Jan 7, 2010 at 9:40 AM, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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


Other related posts: