Forum Discussion
Not sure I entirely understand...
1) You have a script routine that returns a single account number. Does that routine have parameters on it for determining which account number? What exactly does that script routine do?
2) What is inside the loop...the routine that returns the account number or are you using those account numbers to drive a loop that's going to execute something else?
For me, the simplest way to do this is to have the script routine be parameterized to return a particular number of rows/accounts. That would be returned as some sort of array or table that I could then use in a for-loop to loop through that fixed length array. Each time through the loop, execute code with the contents of that record of the array.
All doable in keyword tests, but I'd probably end up writing it in script code.
This is on a Oracle database.
The script routine has no parameters. It returns an account number. There is a rownum = 1 in the Where clause. (This was just a first stab but good enough for prove of concept.)
The five account numbers will drive a loop that's going to execute something else.
Tks.