Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Name-in Function
Hi,
Is anyone aware of a function in PL/SQL equivalent to the NAME_IN function in forms?
Basically, i have a host of variables, v_field_1, v_field_2 etc. The number at the end can vary.
At runtime, depending on the number of fields the query has, i want to use one of these variables. In forms, i could do a loop like
for x in 1..5 loop
name_in('v_field_' || to_char(x) ) := 'blah' end loop;
Any pl/sql equivalents?
Mark Received on Wed Jul 07 1999 - 08:40:45 CDT