Calling a simple stored function with custom type mapping

This Pipeline demonstrates invoking a stored function using the Oracle Stored Procedure Snap by defining a custom type mapping and documenting the indexing behavior. The return value has index 1 and the first parameter has index 2.



  1. The code in the following section defines the stored function - payroll_pkg.employee_info.
  2. We use the Oracle Execute Snap to query people table.


  3. Then, we use the Mapper Snap to map Employee ID and Full name.


  4. We use the Oracle - Stored Procedure Snap and select the stored procedure.


  5. The Oracle Stored Procedure Snap invokes a stored function to lookup employee information, such as the employee's salary and hire date. The function accepts an Employee ID and returns a table of custom types (employee).