Oracle Query v1
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 returns XML content that the Node should consolidate into one XML result.
ResultXml
Type: Xml Output
The ResultXml Property
RowsAffected
Type: Int32 Output
This returns 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.