Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Passing arrays into stored procedures
Hello everyone. I need to pass an array (i.e. all contents of a PL/SQL
table) from Forms 5.0 to a stored procedure on an Oracle 7.3.4
database. I want to try avoiding looping through the array on the forms
side and calling the stored procedure in each iteration of the loop. I
believe a REF_CURSOR will do this, but I believe it is only available
Oracle 8 and higher. Please let me know if I am wrong about this
assumption. Any help would be greatly appreciated.
Thanks in advance!
Kyriakos Lambros Received on Wed Apr 05 2000 - 18:12:25 CDT
![]() |
![]() |