Plsql

[helpme]

Hi,
Now ive deleted all my previous threads and starting a new 1

Here is the plsql code

DECLARE
a2 varchar2(20):='#'
TYPE p_tab IS TABLE OF varchar2(200) index by binary_integer;
lAnswer p_tab;
i number:=0;
BEGIN
FOR x IN (SELECT distinct id FROM TEST_SAM group by id) LOOP
lAnswer(i):='#';
FOR y IN (SELECT name FROM TEST_SAM where id=x.id) LOOP
if a2 ='#' then
a2 := x.id||','||y.name;
else
a2 := a2||','||y.name;
end if;
end loop;
:lAnswer(i):=a2;(ths problem xists on this line and if i remove the colon it works fine..but i need to use the bind it to use it in the browser)
i:=i+1;
a2:='#';
END LOOP;
END;


thanx and sorry if ive offended any1 :)

[sambavan]

Since this could more appropriate on the Development side, I'm taking the liberty to move it over there... Also please post what is the problem on the procedure....


Sam