By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

VB - Oracle Connectivity Issue

P: 3
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?
Jan 9 '08 #1
Share this Question
Share on Google+
4 Replies


QVeen72
Expert 100+
P: 1,445
Hi,

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

Regards
Veena
Jan 9 '08 #2

P: 3
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?
Jan 9 '08 #3

QVeen72
Expert 100+
P: 1,445
Hi,

Try to give Parameter as adUnknown

Regards
Veena
Jan 9 '08 #4

P: 3
On specify data type as UnKnown,i am getting the error "Inconsistent or incomplete info was provided".

ObjCmd.Parameters.Append ObjCmd.CreateParameter("v_return_flag", adUnknown, adParamOutput)
Jan 9 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.