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=""') "CODE1"
extractValue(value(t),'/*/CODE2','xmlns=""') "CODE2"
from wwv_flow_collections c,
table(xmlsequence(extract(c.xmltype001,'//getResponse/SOAP_RESULT/RESULTS/GROUPS/GROUP','xmlns=""'))) t
where c.collection_name = 'P1000_GETGROUPS_RESULTS'

I did it with wizards.



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