OracleQuery

Use the OracleQuery when the data source resides in an Oracle database. The OracleQuery returns a dataset or executes a command (such as insert or update). If the query returns data, the dataset is created as part of the Oracle component. You can display the returned data by using the TableView component.

Oracle client 8.1.7 or greater must be installed on any desktop using the OracleQuery.

When you add this component to an automation, the system places it on the Global tab of the component tray. For more information, see Adding Global Components to an Automation. This component must be global to be referenced by other automations in the project.

For more information, see General Component Properties, Methods, and Events.

Properties

Property	Description
CommandText	The Oracle statement. Use the colon (:) for parameters in the OracleQuery. Note: Do not dynamically change the CommandText if there are parameters in the command.
CommandTimeout	The amount of time you want the solution to wait to execute the query. The default is 30 seconds.
CommandType	Specifies how the CommandText is interpreted. Use Text when the Command Text is a SQL Select statement. Use StoredProcedure when the Command Text is the name of a stored procedure. Use TableDirect when the CommandText is the name of a table.
ConnectionString	The string used to open the data source. To create the Connection String, browse this property to open the Microsoft Data Link Properties window. Click Help for more information.
Parameters	Browse this property to open the Parameters dialog and set default values for parameters used in the CommandText. Note that you must test the query for the query parameters to be fully defined in the project. If you run the project without testing the query in Studio, an error is thrown. Click the Test Query link to test the query with the parameters Note: The size of the parameter you enter when you test the query sets the allowable runtime size limit.
ReturnType	Indicates if the query will return rows of data, a scalar value or no data at all.

Methods

Method	Description	Parameters	Result Type
Execute	Runs the SQL statement against the designated datasource.	As specified by the SQL statement	Void
GetTable	Use this method to return a data table containing the query data.	None	DataTable

Related information

Requirements for the OracleQuery