ODBC - RETURNING ?

From: Freddy Kristiansen <fk_at_dsinet.dk>
Date: Fri, 28 Jan 2000 11:27:25 +0100
Message-ID: <38916f54$0$231@lithium.news.uk.uu.net>

I am connecting to an Oracle 8i database (earlier 7) server using 32 bit ODBC ! One of the new functions in Oracle 8 is the RETURNING clause which in can be used in an INSERT statement to return the ROWID or another unique field to identify the newly inserted row.

Does anyone know how to do this via ODBC ?

INSERT into test VALUES('TEST') RETURNING ROWID INTO :var;

but how do i declare var via ODBC ???

Freddy Kristiansen Received on Fri Jan 28 2000 - 04:27:25 CST