Re: SQL Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 23 Feb 2006 23:51:14 +0100
Message-ID: <d1fsv1h8c1hvroa3cv2td339s91rg7rbsj@4ax.com>

On 23 Feb 2006 10:54:59 -0800, "dean" <deanbrown3d_at_yahoo.com> wrote:

>I'm running some debug code in a program in C++, and I have a grid that
>returns the results of any SQL statement that I care to enter on
>screen. I can see the results of a select query, or I can execute a
>command (such as delete), but in the latter case I can't see any
>responce from Oracle to tell me what happened in the command (for
>example, that 10 rows were deleted). How can I get this last message
>back from Oracle?
>
>Thanks!
>
>Dean

Both Pro*C and OCI automagically return the number of rows affected. As you don't specify which Oracle supplied API you are using your question can't be answered.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Feb 23 2006 - 16:51:14 CST