Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,323 questions
How to Call a ORACLE DATABASE PACKAGE from Azure data factory and receive the output of that package.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 83%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ADFUser
1
Reputation point
Team
I need to call a ORACLE DATABASE PACKAGE from azure data factory and use its output in other activities but i am not able to call a PACKAGE. Inside the package there are many stored procedures written so i need to call a specific stored procedure inside a Package .
Please provide the script or way to do this.
Thanks in Advance
{count} votes
-
Nandan Hegde 34,351 Reputation points MVP2025-03-05T11:52:09.8033333+00:00 can you be more specific? Do you wish to trigger the SP within oracle database and copy its result for some other aspects.
-
ADFUser 1 Reputation point
2025-03-05T11:58:20.32+00:00 Need to call a Oracle database procedure which is inside a PACKAGE.
-
Nandan Hegde 34,351 Reputation points MVP
2025-03-05T12:01:50.34+00:00 So you mean to say you have a package that contains the SP logic and that SP is not present within the Oracle database. Post reading the definition from the package, you want the SP logic to be executed directly within the database without that SP not being physically present within the database?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
J N S S Kasyap 860 Reputation points Microsoft External Staff2025-03-06T00:44:17.06+00:00 Azure Data Factory (ADF) does not natively support direct invocation of Oracle packages. To execute a specific stored procedure within an Oracle package and retrieve its output, you can utilize the
LookuporScriptactivity in ADF to run an anonymous PL/SQL block. This approach allows you to call the desired procedure and handle its output appropriately.
To execute the package procedure and retrieve its output, use aLookup activityin ADF. Write aPL/SQL blockthat declares a variable, calls the procedure, and returns the output using SELECT ... FROM DUAL, allowing ADF to capture the result.
Please refer the below links
https://learn.microsoft.com/en-us/answers/questions/2120741/how-to-call-stored-procedure-in-oracle-from-adf
https://stackoverflow.com/questions/63204428/how-to-call-oracle-stored-procedure-from-azure-data-factory-v2? -
J N S S Kasyap 860 Reputation points Microsoft External Staff
2025-03-06T23:49:40.7633333+00:00 @ADFUser
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. -
J N S S Kasyap 860 Reputation points Microsoft External Staff
2025-03-07T22:02:15.2833333+00:00 @ADFUser
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer