Re: Oracle Function to Return the error text associated with an oracle error code
- From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>
- Date: Thu, 7 Jan 2010 10:34:44 -0500
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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
--
Rumpi Gravenstein
--
//www.freelists.org/webpage/oracle-l
Other related posts:
