Xref: alice comp.databases.oracle.misc:35534 comp.databases.oracle.server:56361 comp.databases.oracle.tools:27907
From: "Mark G" <someone@hot>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools,comp.databases.oracle.server
Subject: Name-in Function
Date: Wed, 7 Jul 1999 14:40:45 +0100
Lines: 21
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <3783568d.0@145.227.194.253>
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!tank.news.pipex.net!pipex!warm.news.pipex.net!pipex!news.fjcomp.com!145.227.194.253!145.227.137.207

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