Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Retrieving multiple records using Oracle ODBC 8.0.5.5 (RDO)
Hi,
I have recently raised up the question on how to return multiple
records using ODBC 8.0.5.5 Driver with RDO connection to ORACLE 8.0.5.
Appreciate the help rendered but still confused and unable to get the
example
working....
Sample Code given :
cn.Connect = "uid=scott; pwd=tiger; DSN=MSLANGORL;"
'enable the MS Cursor library
cn.CursorDriver = rdUseOdbc
'Make the connection
cn.EstablishConnection rdNoDriverPrompt
sSQL = "{call RefTest.GetEmpData(?,?)}"
Set qd = cn.CreateQuery("", sSQL)
qd.rdoParameters(0).Type = rdTypeVARCHAR qd(0).Direction = rdParamInputOutput qd(0).Value = Text1.Text qd.rdoParameters(1).Type = rdTypeVARCHAR
Thanks a million to those of you who helped......
Aik Khoon. Received on Tue Jun 01 1999 - 11:37:15 CDT
![]() |
![]() |