Re: Name-in Function

Can you not change the 'host of variables' to an array, then do:

for x in 1..5 loop

   v_fieldr(x) ) := 'blah'
end loop;

BTW - if you are working on dynamic select statements in PL/SQL, I've just posted a chunk of code on my website.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Mark G wrote in message <3783568d.0_at_145.227.194.253>...


>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;

>