Re: Oracle Collections

amerar_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!

What William suggests or by writing an anonymous block.

DECLARE
   ... define your collection here
BEGIN
   ... load your collection here
   call your proc
END;
/

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org