Hello @Pawar, Mahendra !
Welcome to Microsoft QnA!
In order to access Oracle On Premises you need the Logic Apps Data Gateway :
You have to to log in to the gateway with the same Azure account that you will use in Logic Apps.
Once connected, you should be able to see available operations for the Oracle connector, such as "Execute a SQL Query".
If direct execution of the stored procedure isn't available, you might have to use a SQL query to call it. For instance:
**BEGIN** **your_package_name.your_procedure_name(your_parameter_value);** **END;**
Below are some suggestions for the Timeout Issue:
Ensure that the Oracle database allows connections from the server where the On-Premises Data Gateway is installed.
The On-Premises Data Gateway does encrypt data that travels between on-premises and Azure.
Monitoring and Logs:
Use Azure Monitor and Logic Apps' built-in logging to diagnose any issues.
Also, check logs and monitoring tools on your Oracle server. They might provide insights if the call is reaching the Oracle server and if there are any errors.
I hope this helps!
Kindly mark the answer as Accepted and Upvote in case it helped!