1. Microservices Architecture Documentation
  2. Administer
  3. Data Management
  4. Execute Commands, Stored Procedures, and Queries with SQLEXEC
  5. Using Input and Output Parameters
  6. Passing Values to Output Parameters

Passing Values to Output Parameters

To pass values from a stored procedure or query as input to a FILTER or COLMAP clause, use the following syntax:

Syntax 

{procedure_name | logical_name}.parameter

Where:

  • procedure_name is the actual name of the stored procedure. Use this argument only if executing a procedure one time during the life of the current Oracle GoldenGate process.

  • logical_name is the logical name specified with the ID option of SQLEXEC. Use this argument if executing a query or a stored procedure that will be executed multiple times.

  • parameter is either the name of the parameter or RETURN_VALUE, if extracting returned values.