Oracle Database Nodes

MaestroHub delivers full support for Oracle Database with native SQL and PL/SQL syntax, parameter binding, and connection tuning so you can integrate enterprise workloads seamlessly.

Configuration Quick Reference

Field	What you choose	Details
Parameters	Connection, Function, Function Parameters, optional Timeout	Select the shared Oracle connection profile and configure SQL/PL-SQL statements, stored procedures, and timeouts.
Settings	Retry on Fail, On Error, Notes, Display Note In Pipeline	Control pipeline behavior with retry policies, error routing, and canvas notes.

Oracle Query Node

Oracle Query Node

Execute Oracle Database queries and stored procedures with parameter binding.

Supported Function Types:

Function Name	Purpose	Common Use Cases
Execute Query	Run SQL statements or PL/SQL procedure calls	Production reporting, MES integrations, transactional updates, data analytics