Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Passing arrays into stored procedures

Passing arrays into stored procedures

From: Kyriakos Lambros <kyriakos.lambros_at_lvvwd.com>
Date: 2000/04/05
Message-ID: <38EBC856.2BFEADB6@lvvwd.com>#1/1 






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 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US