Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> PLSQL: Looping thru Variables
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
![]() |
![]() |