6 Replies Latest reply: Apr 5, 2012 7:38 AM by ViPri RSS

    APEX Report not show a Collection of Webservice Results

    ViPri
      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