How to pass array as parameter from VB to a Stored Procedure in Oracle

How to pass array as parameter from VB to a Stored Procedure in Oracle

Post by Greg » Tue, 26 Aug 2003 14:37:19


I have written a stored procedure in Oracle which accepts a varray as IN
parameter.

I need to execute this procedure from VB using ADO.

How will I declare this array in VB.

Could someone provide an example/suggestions.

Please Help !

TIA,

Greg
 
 
 

How to pass array as parameter from VB to a Stored Procedure in Oracle

Post by Paul Cleme » Tue, 26 Aug 2003 21:42:23


I have written a stored procedure in Oracle which accepts a varray as IN
parameter.

I need to execute this procedure from VB using ADO.

How will I declare this array in VB.

Could someone provide an example/suggestions.

It isn't supported by either the Microsoft or Oracle drivers in ADO. You would need to use OO4O (OLE
Objects for Oracle):

http://www.yqcomputer.com/


Paul ~~~ XXXX@XXXXX.COM
Microsoft MVP (Visual Basic)