Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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;
>
Received on Wed Jul 07 1999 - 10:45:01 CDT