Skip to main content

OracleGetCollection

This activity retrieves a collection of data from an Oracle database using a specified SQL query.

Core Functions​

  • Accepts a SQL query as input
  • Sends the query to the connected Oracle database
  • Retrieves the resulting dataset from the database
  • Returns the retrieved data collection

Inputs​

  • Query: Represents the SQL query used to retrieve data from the Oracle database
    Type: String

Outputs​

  • Output: Returns the collection of records retrieved from the database
    Type: DataTable

Short Technical Summary​

A database retrieval activity that executes a SQL query on a connected Oracle database and returns the resulting dataset as a DataTable collection.