Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Retrieving multiple records using Oracle ODBC 8.0.5.5 (RDO)

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

  1. 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(?,?)
  2. I read that RDO 2.0 has some problem with calling syntax : schema.package.procedure
  3. 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US