This discussion is archived
0 Replies Latest reply: Nov 29, 2011 12:05 PM by 900884 RSS

executeSQLQuery() of the XmlViewService fails querying against S_NQ_JOB tbl

900884 Newbie
Currently Being Moderated
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.

Legend

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