Re: Column reference in PL/SQL

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 - 12:25:31 CDT