1 Reply Latest reply: Mar 22, 2013 12:31 AM by Deep00 RSS

    executeXMLQuery Not working as expected in 11g

      What values should be entered for the parameters passed to outputFormat? The result is always 0 records for any junk value given to outputFormat
      I have tried SAWRowsetData etc. along with junk values like "sdfa" and the function seems to get executed without showing any results.
        • 1. Re: executeXMLQuery Not working as expected in 11g - returns 0 rows

          I have the same problem when consuming the OBEE webservice from java. Can somebody please suggest a solution. This is what i have. This always returns 0 rows, where the analysis returns more than 30 rows when executed on OBIEE

          I am using OBIEE

          XmlViewServiceSoap xmlViewServiceSoap = xmlViewService.getXmlViewServiceSoap();

          ReportRef rRef = new ReportRef();

          ReportParams rParams = new ReportParams();
          XMLQueryExecutionOptions xqeo = new XMLQueryExecutionOptions();

          QueryResults qr = xmlViewServiceSoap.executeXMLQuery(rRef, XMLQueryOutputFormat.SAW_ROWSET_SCHEMA_AND_DATA, xqeo, rParams, sessionID);

          String result = qr.getRowset();

          Edited by: Deep00 on 21-Mar-2013 21:57

          Edited by: Deep00 on 21-Mar-2013 22:30