Azure Logic Apps - Oracle Execute Query
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!