Passing an array of values From VB6.0 to Oracle PL/SQL Function

Posted on 16th Feb 2014 07:03 pm by admin

Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL Function we are getting the error like

Error is: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
.

From Database side the function is working fine.

VB code:
objDBConn.Open "PROVIDER=OraOLEDB.Oracle;DATA SOURCE=xxx;USER ID="xxx";PASSWORD="xxx"

Dim Cmd As New ADODB.Command
Dim ArrX(5) As String
ArrX(0) = "0"
ArrX(1) = "1"
ArrX(2) = "2"
ArrX(3) = "3"
ArrX(4) = "4"
Cmd.ActiveConnection = objDBConn
Cmd.CommandType = adCmdStoredProc
Cmd.CommandText = "fn_SampleArray"

-- The below command is not executing.

Cmd.Parameters.Append Cmd.CreateParameter("fn_in_arr", adArray, adParamInput, ArrX)
Cmd.Parameters.Append Cmd.CreateParameter("Result", adVarChar, adParamOutput)
Cmd.Execute

MsgBox Cmd.Parameters(0)
Can you please advice us.

Your Answer:

Login to answer

Other forums

Print out contents of to Excel
I have got this script that gathers all the data that I need but I need it to send it to excel inste

Undefined variables
hi
----------------------------------------------------------------------------------------------

preg_match logical error
Code: <?php
$s = file_get_contents("page.html");
preg_match('/<div cla

How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i

Table sorting
Hi,

I'm trying to modify the following in order to make the output table sorted alphabeticall

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

TCP Sending Unsigned Char...
Hi...

I want to send over tcp/ip some data, i have the data in hexadecimal, and when i tr