You can use script activity to achieve this. In case of look up activity, you can trigger the sp but at the end write a dummy select 1 as test query
how to call Oracle procedure in ADF lookup activity
Shi, Kangwen
0
Reputation points
We need call Oracle Procedure from the Azure Data Factory. It seems that in lookup activity only Select is supported. How can we call the Oracle Procedure without the modification on Oracle side?