Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Name-in Function

Name-in Function

From: Mark G <someone_at_hot>
Date: Wed, 7 Jul 1999 14:40:45 +0100
Message-ID: <3783568d.0@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;

Any pl/sql equivalents?

Mark Received on Wed Jul 07 1999 - 08:40:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US