0

I have a requirement to invoke an Oracle stored procedure in Azure Data Factory pipeline and I tried calling my stored procedure in Oracle function and invoked that function in my pipeline but it is not working.

Is there any way to invoke an Oracle stored procedure in an Azure Data Factory pipeline?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
vanipriya k
  • 1
  • Duplicate of existing SO [question](https://stackoverflow.com/questions/63204428/how-to-call-oracle-stored-procedure-from-azure-data-factory-v2). – Anupam Chand Nov 21 '21 at 13:36
  • Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. – Community Nov 25 '21 at 01:30

1 Answers1

0

Try this.

With stored_procedure as (select function(pass-parameter) as alias from dual) 
select * from stored_procedure schema_name.table_name;
Jeremy Caney
  • 7,102
  • 69
  • 48
  • 77
Nasima Khatun
  • 1
  • 1