Is it possible to call Stored Proc with array/cursor param from ODBC?

From: Hugh Pendry <hpendry_at_trinitech.co.uk>
Date: Tue, 29 Jun 1999 16:42:34 +0100
Message-ID: <7laphb$k77$1@trinitech.demon.co.uk>

(Using VC++ and ODBC API)

I have a stored proc which inserts into many tables. One logical transaction may need to call this many (unknown number) of times. To keep the transaction within Oracle I would like to write a stored proc which would accept an array (a cursor?) of data, this stored proc could then enter all the data within a single transaction.

Does anyone know if it is possible to call a stored proc passing a recordset in as a parameter?

Or am I going to have to handle the transaction outside Oracle?

Thanks a lot

Hugh. Received on Tue Jun 29 1999 - 10:42:34 CDT