Possible to call Stored Proc with array/cursor IN parameter via ODBC?
From: Hugh Pendry <hpendry_at_trinitech.co.uk>
Date: Wed, 30 Jun 1999 10:51:31 +0100
Message-ID: <7lcpb4$q81$1_at_trinitech.demon.co.uk>
Hi
Date: Wed, 30 Jun 1999 10:51:31 +0100
Message-ID: <7lcpb4$q81$1_at_trinitech.demon.co.uk>
Hi
(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 Wed Jun 30 1999 - 11:51:31 CEST