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);

Argument
Description

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).

Oracle® Business Intelligence Web Services Guide Copyright © 2007, Oracle. All rights reserved.