Oracle® Business Intelligence Web Services Guide > Description of Services in Oracle BI Web Services > XMLViewService Service >
executeSQLQuery() Method
Use this method to execute a SQL query and return the results of the query. NOTE: If the results returned exceed one page, you need to use the fetchNext() Method to return the next page of rows.
Signature
QueryResults executeSQLQuery(String sql, XMLQueryOutputFormat outputFormat, XMLQueryExecutionOptions executionOptions, String sessionID);
|
|
String sql |
Specifies the string of SQL code to execute. |
XMLQueryOutputFormat outputFormat |
Specifies the output format (for more information, see ). |
XMLQueryExecutionOptions executionOptions |
Specifies the query execution options (for more information, see XMLQueryExecutionOptions Structure). |
String sessionID |
Specifies the unique ID of the session. |
Returns
Returns the results of the query as one or more rows of data in a QueryResults structure (for more information, see QueryResults Structure).
|