Re: Column reference in PL/SQL

Could some please provide me with an example of how I would go about doin= g
this.

Patrick Lanphier

Didier LENQUETTE wrote:

> Hi !
>
> You can do that with using dynamic SQL and storing a row result in a PL=
/SQL
> array !
>
> Regards !
>
> Patrick Lanphier <planphier_at_psu.edu> a écrit dans le message :
> 37F8D1C7.4CBDFCAF_at_psu.edu...
> > I would like to know how to reference a row by column number. For
> > instance instead of
> >
> > fetch cursor into record;
> > returnvalue = record.column_name;
> >
> > I would like something like
> >
> > fetch cursor into record;
> > returnvalue = record.column[1];
> >
> > This would allow me to write a dynamic column fetch routine.
> >
> > Patrick Lanphier
> > Advanced Information Technologies
> > The Pennsylvania State University
> >
> >
> >
Received on Mon Oct 04 1999 - 13:52:17 CDT