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
Did you know?Explore Trending and Topic pages for more stories like this.
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.
tag inside php...
hi
Code: <?php
echo "<td width="$columnWidth%" align=&OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an Get last modified date of web page
Hai All,
In php how can i get last modified date of a give web page . I have tried to g IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying
Custom list order
Hi there,
I have checked this tutorial and it's great till the point where I want to display count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men IF Statement & Two Tables With Different Echoes
I'm retrieving two tables in a single query using UNION ALL, like so:
Code: $query = "SE $_POST
Hi, I have 2 seperate php files, and i want my $_POSt["fname"] To go into both of them, Fo Grouping and sorting results
Please help with this query.
I have 2 tables in a database, countires and cities. states look Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w
| 
