Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pass a table to a procedure
Or you can just pass a plain old PL/SQL table.
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3BABC021.7AEC_at_yahoo.com...
> 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..."
>
Received on Sun Sep 23 2001 - 22:10:28 CDT