This discussion is archived
1 Reply Latest reply: Mar 21, 2013 10:31 PM by Deep00 RSS

executeXMLQuery Not working as expected in 11g

939242 Newbie
Currently Being Moderated
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
    Deep00 Newbie
    Currently Being Moderated
    HI

    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 11.1.1.6.5

    <code>
    XmlViewServiceSoap xmlViewServiceSoap = xmlViewService.getXmlViewServiceSoap();

    ReportRef rRef = new ReportRef();
    rRef.setReportPath("/xyz/abc/reportName");

    ReportParams rParams = new ReportParams();
    XMLQueryExecutionOptions xqeo = new XMLQueryExecutionOptions();
    xqeo.setRefresh(true);
    xqeo.setPresentationInfo(true);

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

    String result = qr.getRowset();
    </code>

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

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

Legend

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