We would like to create a pipeline that performs as a final step the insertion / update of data in an Oracle database via the execution of an Oracle SQL Stored Procedure.
Therefore, we would like to ask you if it is possible to call an Oracle SQL Stored Procedure either via a built-in Destination component or a custom Destination component.
If the above approach is feasible, could you please provide a list of steps to perform the operation?
can you please try with jdbc query as destination and call the procedure in it. It works for me and below the snaps for your reference.
Thanks & Regards