Re: Handling error with powerBuilder from Oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 05 Nov 2001 19:19:01 +0100
Message-ID: <ptlduto70p7e8dkfi87q0kdr8qck333urq@4ax.com>

On 5 Nov 2001 07:57:23 -0800, alemori_at_hotmail.com (Alejandro) wrote:

>Hi, I want capture el ErrorText from a Store Procedure write in Oracle
>but I have a problem. Somebody know how to do it ???
>
>Thank You

There are various methods.
The simplest is setup an OUT parameter and use
<var> := sqlerrm;

and you're don
You could also use
<var> := dbms_utility.format_error_stack; for a more complete picture

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 05 2001 - 12:19:01 CST