Question

Call of Oracle SQL Stored Procedure as Pipeline Destination

  • 7 March 2023
  • 1 reply
  • 81 views

Hello, 

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?

Thank you,

Bolgas


1 reply

Userlevel 5
Badge +1

@bolgas 

 

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

Bikram_

Reply