Here is my scenario, I have on premise Oracle database which having package (Package contain multiple stored procedure- xxxxA_Pkg \Sp_ABC.). In Biztalk have different options to consume the package So as part of Biztalk to Azure Logic app migration, I need to consume the same oracle package from my Logic app. I have tried with Managed Oracle Adapter, unfortunately which is not providing the option to execute the package. So, I can't go with Managed Adapter and need to find another possible way to make this functionality. It will be helpful if i am getting valid suggestions. Thank you in advance.

@Chandran, Vinitha Thanks for reaching out. Logic app does support oracle connector but unfortunately there are no actions/trigger that can help you to run the package from logic app. As the Oracle Database connector doesn't support executing packages directly. Instead, you can use the "Execute a SQL query" action if this could help with your use case. Alternatively if there are any API's from Oracle end that can help you then you can create your custom connector for your requirement.

How we can consume on premise Oracle Database package from Azure Logic app

Accepted answer

MayankBargali-MSFT 70,731 Reputation points

2023-11-20T10:19:06.51+00:00

@Chandran, Vinitha Thanks for reaching out.

Logic app does support oracle connector but unfortunately there are no actions/trigger that can help you to run the package from logic app.

As the Oracle Database connector doesn't support executing packages directly. Instead, you can use the "Execute a SQL query" action if this could help with your use case.

Alternatively if there are any API's from Oracle end that can help you then you can create your custom connector for your requirement.
Please sign in to rate this answer.
Chandran, Vinitha 40 Reputation points

2023-11-22T13:47:34.74+00:00

Thank you very much @MayankBargali-MSFT . One more possibility I am looking. Can we achieve this via Azure functions.

MayankBargali-MSFT 70,731 Reputation points

2023-11-22T14:37:36.47+00:00

@Chandran, Vinitha From the function perspective yes you can connect to onprem resource from the azure function. You can refer to this document to create the hybrid connection and how it works. The hybrid connection is not supported in Consumption Plan and works with Windows OS for azure function with other plans as mentioned in this article. You need to create the function app under the app service plan.
Reference: https://learn.microsoft.com/en-us/azure/azure-functions/functions-networking-options#matrix-of-networking-features

I am not expert in Oracle library but I think you can use their library to execute the package.

Chandran, Vinitha 40 Reputation points

2023-11-22T15:51:36.4533333+00:00

If i am proceeding with Execute Stored Procedure, EXEC_SQL what is the SQL_TEXT value format. Could you please help me to make format it

I need to invoke my Package Package1. Sp1.

MayankBargali-MSFT 70,731 Reputation points

2023-11-24T02:05:04.0233333+00:00

@Chandran, Vinitha Can you please create a new issue so this could help other community members with the similar issue.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How we can consume on premise Oracle Database package from Azure Logic app

0 additional answers

Your answer