Re: VB5+STORED PROCEDURE+ARRAY

Corrado Fantuz schrieb:
>
> 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 ;-)

Hi,

take a look at Oracle Objects for OLE (OO4O). The're shipped for free with the oracle clients sw. Just install them and read %oracle_home%\mshelp\oracleo.hlp. They provide a mechanism to pass a PL/SQL-table as parameter array.

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Wed Jan 13 1999 - 00:37:43 CST