This discussion is archived
6 Replies Latest reply: Apr 5, 2012 5:38 AM by ViPri RSS

APEX Report not show a Collection of Webservice Results

ViPri Newbie
Currently Being Moderated
Hi everybody,

I'm see a Collection in Session State view.
But Report show "no data found".

Report Select:
select extractValue(value(t),'/*/CODE1','xmlns="http://my.com/"') "CODE1"
extractValue(value(t),'/*/CODE2','xmlns="http://my.com/"') "CODE2"
from wwv_flow_collections c,
table(xmlsequence(extract(c.xmltype001,'//getResponse/SOAP_RESULT/RESULTS/GROUPS/GROUP','xmlns="http://my.com/"'))) t
where c.collection_name = 'P1000_GETGROUPS_RESULTS'


I did it with wizards.



Thanks,
Vitalijus

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points