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

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

DOMDocument
Hello All,

I need to take an XML document, modify some of the nodes in it and then perform a

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

Business Health Check
Hello

I need to create an online business health check for a client it will be multiple choi

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

matching numbers inside ( )
I know I can match numbers by just [0-9]+, so I thought matching numbers inside ( ) would be somethi