 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 |
|
|
Hi,
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
Michael
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
