ADO, packages, stored procs with tables

From: Stuart Wachsberg <stuart_at_vertigoxmedia.com>
Date: Thu, 4 Oct 2001 16:34:55 -0400
Message-ID: <9pig0g$24kf$1@cti15.citenet.net>

When executing a stored proc that has a table as an out parameter, ADO does not seem to be able to handle it (the error message says that is does not have type information on the parameter).

Also, I have trouble executing any procedure in a package that has out parameters (ADO thinks there are zero parameters). For example, in the following package definition below, ADO cannot access the two procs since they have OUT params.

Can someone please confirm that ADO can or cannot handle the above-mentionned?

Thanks, Stuart Wachsberg

CREATE OR REPLACE PACKAGE stuart_pkg
IS
 TYPE StuartType IS TABLE OF stuart.NAME %TYPE INDEX BY BINARY_INTEGER;

        stuart_tab   StuartType;
        PROCEDURE stuart_getname


                (stuart_tab        OUT     StuartType);

 PROCEDURE stuart_getnum


                (num        OUT     NUMBER);

 PROCEDURE stuart_update(num in NUMBER);

END stuart_pkg;

CREATE OR REPLACE PACKAGE BODY stuart_pkg IS

        PROCEDURE stuart_getname (stuart_tab        OUT     StuartType)
        as

 begin
  stuart_tab(0) := 'hello';

     END stuart_getname;

 PROCEDURE stuart_getnum

(num OUT NUMBER)
 as begin
  num := 10;
END stuart_getnum;
 END stuart_pkg; Received on Thu Oct 04 2001 - 15:34:55 CDT