Victor Engmark wrote:
> The second (present) solution is to select everything into a %ROWTYPE
> variable, but I have not been able to find a simple way of extracting
> the column data:
> - Data in records do not seem to accessible using numbered indexes
> - I believe the FORALL structure only works for tables, not records(?)
> - I cannot seem to be able to use a variable containing a column name to
> reference a column, as in "l_record.l_colname"
> - I have no idea of how to "convert" a record into a number indexed
> construct without explicitly specifying the column names
It should be mentioned that I've tried passing the column name and
record to a dynamic PL/SQL statement, but it doesn't seem to accept
records as IN variables.
--
Victor Engmark
Received on Mon Oct 25 2004 - 06:45:34 CDT
