Hi everyone!
I have a problem I cant seem to find a sollution for.
I am developing a function that will create an document for a selected number of rows in the database...
the way it works is that when the function is started
The following is send to the oracle procedure
"order number, part_number and row_number"
Then my procedure performs logic for this row in several steps...
The first "application" all that does is extracts the variables from the screen like:
x:= &x;
y:=&y;
z:=&z;
----------------------------------------
Then it calls the procedure with
start_my_procedure(x,y,z);
Then the procedure handles these values into a string
str :='x'||x||'y'||y||'z'||z;
and then
finish_procedure(str);
This is the simplified version of what the procedure does...
It works perfectly when there is just one row...
What I want to be done is when the user in the GUI-application selects more than one row, I want the next row to be added to the first one...
so the str will be: xxyyzzxxyyzzxxyyzzxxyyzz
So I understand i need to make a loop or an array or something similar but the problem is that I dont know how many rows will be selected...
Any sollution for this? with a simple example would be helpful:-p
thanks a lot!
/Niklas