0 Replies Latest reply: Nov 29, 2011 2:05 PM by user2221085 RSS

    executeSQLQuery() of the XmlViewService fails querying against S_NQ_JOB tbl

    user2221085
      Hi,

      According to the Oracle BI WS API doc, the XmlViewService's executeSQLQuery() should be able to execute any query. However, when I call it with a query against the S_NQ_JOB table, it comes back with "Unresolved table:..." error. Does executeSQLQuery() support any query or just a particular set of table in Oracle BI? Here's an excerpt of the line of code which I use to produce the error:

      QueryResults result = xmlViewService.executeSQLQuery("SELECT * FROM DEV_BIPLATFORM.S_NQ_JOB", XMLQueryOutputFormat.SAWRowsetData, new XMLQueryExecutionOptions(false, 100, true, true, "XXX"), sessionID);

      Thank you for any response.