Oracle Query

Executes SQL queries against an Oracle database and returns the result set as an XML document.

Revision History

1.0.0.0 Initial Release
1.0.0.1 Bug fixes and support for custom properties

Properties

Connection

Type: Connection Input

DataSource
Type: String
Typically specified in the form server:port/servicename.

Username
Type: String
The username to be used for the connection.

Password
Type: Password
The password to be used for the connection.

Query

Type: Multiline Text Input
The SQL query text

XmlQuery

Type: Boolean Input
When True, indicates that the query provided in the Query property is an XML Query (ie. a query containing the FOR XML statement - refer to http://msdn.microsoft.com/en-us/library/ms178107.aspx for more information on XML queries).

ResultXml

Type: Xml Output
The ResultXml Property

RowsAffected

Type: Int32 Output
This return the number of rows returned by SQL. Note that for Xml Query, this is not accurate because the xml string gets split into rows in the result, which is consolidated in the node.

Remarks

Use this Connector to execute SQL queries against an Oracle database.

SQL Parameters via Custom Properties

Flowgear Custom Properties can be added to this Node to make SQL parameters available in the Query Property.

See Also

Oracle Table Update