Adodb & Oracle Function

12-17-2003, 05:55 AM
Is it possible to get the return value from an Oracle Function by using ADODB command object ? The return type is an array.

I know how to get the numeric type return value. But doubting about an array

Pls give some ideas

12-17-2003, 06:03 AM
Ultimately this depends on whether or not the Oracle provider supports this but you can specify the Type property of the Parameter object as both adArray and the specific data type.

' ie:
Set objParameter = objCommand.CreateParameter("ReturnValue", adInteger Or adArray, adParamOutput)

12-17-2003, 06:09 AM
Thanks 00100b

I had a doubt of that and I was planing to update some fields in a table and read from VB,instead of returning the array.

Now Io can use an array as returning type of Ora Function.

Many more thanks

12-17-2003, 06:15 AM
And one more help related to this. Can we get multi dimension array as a return data type. (Oracle function's returnig type is a record which has more than one coloumn)

Thanks in Advance

12-17-2003, 06:39 AM
Typically, when a stored procedure returns a record or cursor (a collection of records), that record set is captured using a RecordSet object.

I don't know of a way to use a multi-dimensional array as a return type for a Parameter object.

12-17-2003, 09:15 AM
Thanks I will try both recordset object and Parameter/Command object.
(Im also doubting the multi dimension array type as return type)

Many more Thanks

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum