Hi,
I am trying to return a recod from from my function but for some reason
it does not work.
Here is may problem. I use a for loop to generate the first batch of
records. Once the loop is completed I want to add another record. But at
that point fails.
....
FOR rec IN SELECT ....
LOOP
RETURN NEXT r;
END LOOP;
do some assignments
RETURN r;
....
It seems that the function does not return anything after the loop. Can
anyone help me on that ?
Thanks
Alex