Binding Arrays using OCI for PL/SQL Blocks

Hi all,

The environment is as follows:

	HPUX 9.04
	Oracle 7.0.16 with PL/SQL and
	the distributed option.
	Oracle Call Interfaces

And the problem is:

I want to pass an array of records to a PL/SQL block that iteratively goes through all of them and updates/inserts data in a table. To maintain atomicity of the transaction I would rollback all the updates/inserts if any one fails. I understand that I can do this in the application code by establishing a transaction, calling a stored procedure in a loop and committing the entire transaction on success. However, I would really like to hide this from the application code.

As something to think of, can I use "obndra()" to bind in arrays of input parameters and then have a cursor to iterate through it?

Does anyone have any pointers? All help will be greatly appreciated.

Thanks!

Pavan.

-- 
Pavan V. Muzumdar
Cambridge Technology Partners, Cambridge, MA 02139.
Tel: (617) 374-9800  Fax: (617) 374-8300
E-mail: pmuzu_at_ctp.com