VB5+STORED PROCEDURE+ARRAY

From: Corrado Fantuz <corrado.fantuz_at_snam.eni.it>
Date: Tue, 12 Jan 1999 16:28:43 +0100
Message-ID: <369B6A2A.F311E6C4@snam.eni.it>

Hi all
i'm working with Oracle7 Server Release 7.3.4.0.0 and VisualBasic 5.0(SP3) using ODBC.

My questions is :

is possible with VB5 call a STORED PROCEDURE passing an ARRAY ???

I've create a package as :

CREATE OR REPLACE PACKAGE PK_1
IS

TYPE tab_c_some IS TABLE OF tab_some.some%TYPE

                INDEX BY  BINARY_INTEGER;

END PK_1;

I've create a STORED PROCEDURE as :

CREATE OR REPALCE PROCEDURE my_proc

( v_some PK_1.tab_c_some ) IS

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


-------------------------------------------------

Whit Visual Basic i call my_proc as:

    dim sql as string
    sql = "P1352P28(?)"
    sql = "begin " & sql & "; end;"
    Set qdfTemp = dbCsicli.CreateQuery("", sql)     With qdfTemp

        .rdoParameters(0).Direction = dbParamInput
        .rdoParameters(0).Type = rdTypeINTEGER
       .rdoParameters(0).Name = "some"
        Set rstTemp = .OpenResultset()

End With

With ".Type=rdTypeINTEGER" i've an ERROR, will i use a different "type" or will i use a different mechanism ??

Thank you,
Flavio

P.S. Sorry for my ENGLISH ;-) Received on Tue Jan 12 1999 - 09:28:43 CST