Re: Pass a table to a procedure

Nuno Souto wrote:
>
> 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

You could always use the object types with table and cast to send an array of data to/from procedures/functions/et al.

Cheers
COnnor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."