|
-
hi.. heres the porblem
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;
i:=i+1;
a2:='#';
END LOOP;
END;
This works fine in sql plus..with me binding the plsql table lAnswer.
When i try to bind lAnswer(some thing lisk this :lAnswer) ,it gives me an error in sql plus asking me to define the bind variable(lAnswer)
Actually i need to bind this varibale and use it in php for displaying in browser.
Thanx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|