| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL table question
I have a two PL/SQL tables; I am trying to create a string. Inside the
loop for the first table, I get the values for the second table and
concatenate the two to form a string.
The problem I am facing is that the last value of the first loop is being repeated after the last loop! Has anyone faced this problem and how did you get around it - would be very interested to know.
Thanks,
IB
Code:
WHILE j <= l_resp.LAST
LOOP -- resp loop
dbms_output.put_line(l_resp(j).data_string||v_step);
i := l_country.FIRST;
v_step := 4;
WHILE i <= l_country.LAST -- country loop
WHILE i IS NOT null -- country loop
LOOP
dbms_output.put_line(l_resp(j).data_string||v_step);
END LOOP;
![]() |
![]() |