Re: Connecting to Oracle From VB6

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

mboizeau_at_free.fr
Date: 01/20/05 

Date: 20 Jan 2005 05:06:13 -0800

I don't understand your first question but yes, some providers have
troubles with huge amount of data.( i didn' encounter this problem
since oracle 7)

to access stored procedure, you should use a syntax like this one
(oCmd is an ADO Command object
and Oconn is an ADO Connection
oRS
Cur_result is your oracle Cursor return type. )

set oCmd.ActiveConnection = oConn;

sSQL = "{call " & sProgStockName & "({ResultSet 0, Cur_Result},'"
&arg1 & "','" & arg2"')}"

oCmd.CommandType = adCmdText
oCmd.CommandText = sSQL
oRS = oCmd.Execute ()

hope this helps
OracleVsMicrosoft

http://OracleVsMicrosoft.blogspot.com