Retrieving multiple records using Oracle ODBC 8.0.5.5 (RDO)

From: Aik Khoon <panadol_at_singnet.com.sg>
Date: Wed, 2 Jun 1999 00:37:15 +0800
Message-ID: <7j123b$oqt$1@clematis.singnet.com.sg>

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

The runtime error complains of problems with Object Collection, which I presumed occurred because of the ODBC Driver inability to recognise the package syntax : call RefTest.GetEmpData(?,?)
I read that RDO 2.0 has some problem with calling syntax : schema.package.procedure
Where can I get information on this aspect of retrieving records using PL/SQL through VB5.0 or at least the version of the driver that has been proven workable ?

Thanks a million to those of you who helped......

Aik Khoon. Received on Tue Jun 01 1999 - 11:37:15 CDT