Home » SQL & PL/SQL » SQL & PL/SQL » *URGENT** Cursor variables
*URGENT** Cursor variables [message #365829] Thu, 10 February 2000 23:46 Go to next message
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
Re: *URGENT** Cursor variables [message #365832 is a reply to message #365829] Fri, 11 February 2000 07:46 Go to previous message
Thierry Van der Auwera
Messages: 44
Registered: January 2000
Member
Hallo Meera,

By my knowlegde this is not possible.
A way to do something like that is with Dynamic Sql.

Greetings,

Thierry.
Previous Topic: How to find sql statements executed in a session
Next Topic: how to insert a date and time field in SQL
Goto Forum:
  


Current Time: Thu Mar 28 05:08:44 CDT 2024