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

Oh its 9.2i, Windows, ADO, on a Borland compiler.

So something like:

select get_last_error_msg as MSG from dual

On 23 Feb 2006 10:54:59 -0800, "dean" <deanbrown3d (AT) yahoo (DOT) com> wrote:

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

Sorry I don't know anything about OCI - we used it years ago in low
level programming calls but not any more. How can I tell?

Is there no simple SQL query I can run as a select statement from dual,
or something like that?

Thanks!

Dean

"dean" <deanbrown3d (AT) yahoo (DOT) com> wrote

: Sorry I don't know anything about OCI - we used it years ago in low
: level programming calls but not any more. How can I tell?
:
: Is there no simple SQL query I can run as a select statement from dual,
: or something like that?
:
: Thanks!
:
: Dean
:

what are you using to establish the connection with the Oracle database?

what grid are you using?

likely it's a grid property

there is no such message or select statement to submit to oracle -- if you
were coding PL/SQL or issuing your own SQL statements, you could check
SQL%ROWCOUNT (or ROWCOUNT for a specific variable) or depending on the
environment you issue your SQL from check the SQLCA (IIRC -- it's been
awhile)

but if you're using a grid control, the grid control is managing the SQL for
you, and it will be reponsible for returning the status

so i'm guessing really isn't an oracle question but a grig control question

++ mcs

Its derived from TtsDBGrid (Top Grid). And it uses ADO to connect to
Oracle.