Name-in Function

[Quoted] [Quoted] 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 [Quoted] at the end can vary.

[Quoted] 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 - 15:40:45 CEST