VB - Oracle Connectivity Issue

[reachravi]

Hi,



In our ASP application, we are using a visual basic Dll file to perform database operations. We have a function in our Dll file for executing stored procedures.



This function takes 3 input parameters from ASP

1. Connection String

2. SQL String (call stored procedure string)

3. Input Parameters.



We are using “Microsoft ODBC for Oracle” drivers for the database connectivity .Due to some crash problems; we have changed the drivers to “Oracle 10g Drivers”. After changing this none of the procs seem to work





Sample SQL String -> “{call Package.Stored_ Proc(? , {resultset 100, v_flag })}"

? is for the input parameter which we will add using ADODB.Command object

V_Flag is the output parameter which we directly specify in the call proc statement.



When we are using “Microsoft ODBC for Oracle” drivers, it is working fine. But when we are changing the drivers to “Oracle 10G”, it is throwing error “V_Flag : Invalid Identifier” and the proc is not getting executed.



Is anyone aware of this problem/work around?

[QVeen72]

Hi,

Create Parameter for Out Recordset also.. Instead of specifying,

Regards
Veena

[reachravi]

the problem is that the out paramter in oracle is of type Table Of Integers.What do i give in vb.

For the input paramter in vb,i have not given the data type.How to do the same for output?Is there any datatype in vb similar to "Table of Integers" in oracle?

[QVeen72]

Hi,

Try to give Parameter as adUnknown

Regards
Veena

[reachravi]

On specify data type as UnKnown,i am getting the error "Inconsiste nt or incomplete info was provided".

ObjCmd.Paramete rs.Append ObjCmd.CreatePa rameter("v_retu rn_flag", adUnknown, adParamOutput)