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

Chandran, Vinitha 20 Reputation points

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.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,557 questions
{count} votes

Accepted answer
  1. MayankBargali-MSFT 64,091 Reputation points

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

0 additional answers

Sort by: Most helpful