Azure Logic Apps - Oracle Execute Query

Gagnon-Bélanger, Félix 1 Reputation point
2021-09-29T14:26:05.927+00:00

Hello Everyone,

I am working on an Azure Logic Apps integration which insert data into an on-premise Oracle Database.
I can successfully run the Logic Apps integration and insert the data into our Oracle table (a custom staging table).

I would like to run a truncate on that table before inserting the new data.
I added the Oracle - Execute a Oracle Query component and then provided the following query:
TRUNCATE TABLE <SCHEMA>.<TABLE_NAME>;

After deploying to Azure, the integration failed on the Execute a Oracle Query with error:
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Unable to find the requested .Net Framework Data Provider. It may not be installed.\r\n inner exception: Unable to find the requested .Net Framework Data Provider. It may not be installed....",

If I remove the Execute a Oracle Query component, the Oracle Insert row component works fine.
I am not sure why it says the gateway may not be installed.

Is that how the Execute a Oracle Query is supposed to be used?
Otherwise, how can I execute the truncate?

Thanks!

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,242 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.