Re: Pass a table to a procedure

On Fri, 21 Sep 2001 10:50:55 +0200, "Pierluigi Sbaiz" <pierluigi.sbaiz_at_elsag.it> wrote:

Dunno about making a table of %ROWTYPE, never tried it. But you can definitely create a type as an object with attributes equal to the row columns, then create a nested table or varray of the object type and use that as a parameter.

Alternatively, if this is called from PRO*C, you can use a host array. This is received by PL/SQL as an INDEX BY table.

>
>Perhaps I need to pass a cursor of the table to my procedure?
>

Functions can return cursors, but I don't think procedures can accept a cursor as parameter?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Sep 21 2001 - 07:06:21 CDT