Re: Oracle Collections

From: William Robertson <williamr2019_at_googlemail.com>
Date: Sat, 22 Sep 2007 12:21:59 -0000
Message-ID: <1190463719.159916.37630@w3g2000hsg.googlegroups.com>

On Sep 21, 7:25 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hi,
>
> I need to test a procedure. The procedure has like 15 input
> parameters, and 1 output parameter. Of the 15 input parameters, one
> of them is a collection.
>
> How can I simulate this EXECUTE statement from SQLPLUS???
>
> Thanks!

Something like

exec myproc(mycollectiontype('Banana','Fruitcake','Hatstand'))

or else code an anonymous block in which you declare and populate a suitable collection. Received on Sat Sep 22 2007 - 07:21:59 CDT