Oracle Stored Procedure with user-defined parameters

In this example we will call a Oracle Stored Procedure PROC_WITH_CUSTOM_IN_PARAM which has parameters of user-defined types.



Download this Pipeline
  1. Here is the definition of the stored procedure PROC_WITH_CUSTOM_IN_PARAM:
  2. First we use a JSON Generator Snap to pass parameter values as shown below to the Stored Procedure Snap:






To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.