Re: Raise Application Error and Power Objects

In article <vinodb-1309951038230001_at_bidark_mac.sdt.com>, vinodb_at_sdt.com (Vinod Bidarkoppa) wrote:

> I have used 'Raise application_error' clause in the exxception block in a
> stored procedure but am unable to handle it in my client application i.e.
> Oracle Power Objects.
> Can anyone give me some idea how to handle return value of 'raise
> application_error in the client program (Power Objects)?

Have you looked at the Oracle Basic functions SQLERRCODE, SQLERRTEXT and SQLERRCLASS or the "exec SQL whenever sqlerror raise" statement? User's Guide chapter 9.

Michael Kranzdorf                                    mikek_at_krt.com
Kranzco Realty Trust                                  610.941.9292