*URGENT** Cursor variables [message #365829] |
Thu, 10 February 2000 23:46  |
meera
Messages: 5 Registered: February 2000
|
Junior Member |
|
|
v_col_value:='c_temp_rec' || '.' || v_col_name;
In the above statement c_temp_rec is a cursor.
say for eg, if v_col_name=last_name, then
v_col_value:=c_temp_rec.last_name;
In the above statement, v_col_value has the literal 'c_temp_rec.last_name'assigned to it, but I would like it to assign
the actual value contained in 'c_temp_rec.last_name'.
Is there a way to do it? It is necessary for me to use the v_col_name instead of directly using the string 'last_name' in the above assignment. It will be great if somebody can help. Thanks
|
|
|
|