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

Home -> Community -> Usenet -> c.d.o.misc -> PLSQL: Looping thru Variables

PLSQL: Looping thru Variables

From: Mark Aurit <mark_aurit_at_mail.northgrum.com>
Date: Mon, 10 Aug 1998 16:41:02 GMT
Message-ID: <35cf2172.3987573@news.northgrum.com>


I call a routine, passing it 3 variables: var1,var2,var3, which contain the values 'CHEVY','SATURN','OLDS' (actually, a lot more than 3 get passed).

From that routine, I want to call another, passing it the values of the variables from within a loop, along the lines of:

FOR i = 1..3 LOOP

        foo('var'||i);
END LOOP; Foo() is receiving the values 'var1','var2','var3', and not 'CHEVY','SATURN','OLDS'. Any help would be greatly appreciated.

Mark
mark_aurit AT mail.northgrum.com Received on Mon Aug 10 1998 - 11:41:02 CDT

Original text of this message

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