1 how do I

Using Oracle classes , in c++

Call a stored procedure which has a parameter of this type

     type tdata is table of varchar2(16) index by binary_integer

I'm trying to do this in c++ and using toad's sqlplus window, like so

declare

Type tdata is table of varchar2(16) index by binary_integer; data tdata;

Type taction is table of number index by binary_integer; action taction;

id number := 101;
returncode number;

begin

         mypackage.get_items(id, fund, action); end;

when I try to run this it says either the wrong number or type of parameters. Here's the proc defined

procedure get_items(comp in number, data out tdata, action out taction)

Thanks

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 12 2000 - 22:01:36 CET