Home » Developer & Programmer » Precompilers, OCI & OCCI » oci array bind to pl/sql function with varray input parameter
icon5.gif  oci array bind to pl/sql function with varray input parameter [message #112532] Sat, 26 March 2005 18:12
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member


I want to pass an OCI bind array of size 20 to a stored PL/SQL function with a defined input parameter defined as a varray.

The intension is to reduce network trafic (via bind array), pre processes each array element in the PL/SQL function and perform a FORALL bulk insert/update/delete against the database to reduce the number of context switches between the SQL and PL/SQL components, claimed to be a factor of 10 faster than non-bulk operations.

My questions are:
1. is it possible to have a varray on a pl/sql input parameter?
2. does an oci bind array map to a varray?
3. do you have an example?

Any help or opinions would be gratefully accepted.

Kind regards

Previous Topic: pro*C
Next Topic: Date
Goto Forum:

Current Time: Wed Nov 25 22:54:04 CST 2020