Re: How get oracle message error on exception on PL/SQL

From: Zbigniew Sliwa <zibi_at_at_hotmail.com>
Date: Wed, 30 Aug 2000 05:53:39 GMT
Message-ID: <Dj1r5.7104$IK4.174601@news.tpnet.pl>

Francky,

In an exception handler, you can use the functions SQLCODE and SQLERRM to find out which error occurred and to get the associated error message.

BEGIN
...
EXCEPTION
  WHEN OTHERS THEN
    RETURN SQLerrm;
END;

---

Regards,

Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com

Francky napisa³(a) w wiadomo¶ci: <8odm12$1n03$1_at_news6.isdnet.net>...
>In my PL/SQL code I get exception in section EXCEPTION / WHEN OTHERS, and I
>want trace the Oracle message associated? How I can do this ?
>Thanks
>--
>
>
Received on Wed Aug 30 2000 - 00:53:39 CDT