VB5, ODBC, and ORACLE 7.3

From: toglime <_at_(toglime)yahoo.com>
Date: Mon, 24 Jan 2000 10:07:00 +0100
Message-ID: <388c144e.0@etsv0008>

Hi
i'm work with VB5 and i'm connect to an Oracle DB with ODBC. With "CreateQuery" is possibile call a Package that return a 'TABLE' off user-defined records?? What is the name of the Type ??? Es.

I have a package pk1. The procedure p1 have an in-out parameters of pk1.TabTa00Type

.....................................................................................................................

CREATE OR REPLACE PACKAGE pk1
AS

    TYPE TabTa00Type IS TABLE OF ta00%ROWTYPE

             INDEX BY BINARY_INTEGER;
   PROCEDURE p1 ( key CHAR, result IN OUT TabTa00Type);

END pk1;
/
CREATE OR REPLACE PACKAGE BODY pk1
AS

   PROCEDURE p1 ( key CHAR, result IN OUT TabTa00Type) IS

      myresult TabTa00Type;
   BEGIN

     myresult.x=0
     myresult.z="XXXXX"

   END p1;

END pk1;

.....................................................................................................................

Whit VB5 and RDO i call the pk1.p1 procedure. Can i read the parameter 'TABLE'

.....................................................................................................................

    sql = "begin pk1.p1(?,?) "; end;"
    Set qdfTemp = dbSAMPLE.CreateQuery("", sql)     With qdfTemp

         .rdoParameters(0).Direction = rdParamInput


        .rdoParameters(0).Type = rdTypeINTEGER


        .rdoParameters(0).Name = "KEY"


        .rdoParameters(0).Value = parCodKey





        .rdoParameters(1).Direction = rdParamOutput


        .rdoParameters(1).Type = ????? <-------------------Exitsts a

type for 'TABLE' (TabTa00Type) ????

.....................................................................................................................

Thanks to all Received on Mon Jan 24 2000 - 03:07:00 CST