Skip to main content
Question

Call of Oracle SQL Stored Procedure as Pipeline Destination

  • March 7, 2023
  • 1 reply
  • 154 views

bolgas
Fan

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

Bikram
Headliner
Forum|alt.badge.img+1
  • Headliner
  • 486 replies
  • March 7, 2023

@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_