Oracle Database Advanced icon

Oracle Database Advanced

Oracle Database com recursos avançados para cargas pesadas e Oracle 19c+. Suporte para thin/thick mode.

Oracle Database Advanced

AI-generated

Summary

Executes SQL queries, PL/SQL blocks, stored procedures/functions, bulk inserts, transaction blocks, or retrieves Oracle Advanced Queuing (AQ) queue info based on the selected operation type.

Inputs

  • operationType (required) — Choose operation: query, plsql, procedure, function, bulk, transaction, or queue.
  • statement (required) — SQL query or PL/SQL block to execute (used for query, plsql, procedure, function, transaction; ignored for bulk and queue).
  • connectionPool — Pool type: standard, highvolume, oltp, analytics, or single connection.
  • bulkTableName — Target table name for bulk insert (shown only when operationType is bulk).
  • params — List of parameters to bind to the statement; each parameter defines name, value, and data type (string, number, date, CLOB, or OUT).

Output shape

Returns an array containing a single JSON element whose content depends on operationType:

  • query: array of rows from the SELECT statement.
  • plsql/procedure/function: object with execution info (success, executionTime, outBinds, implicitResults, rowsAffected, warnings).
  • bulk: bulk insert result object (operation, totalRows, successfulRows, failedRows, batchCount, duration, errors).
  • transaction: object {success:true, results: array of results per statement}.
  • queue: queue info object (queueName, queueType, maxRetries, retryDelay, retentionTime, messageCount, pendingMessages, queueTable, owner, isStarted).

Links

Discussion