Hi Power Automate users,
We have been able to connect to Oracle Database successfully by using 'Get Rows' Connector, but the additional connector 'Execute a Oracle Query' which seems to be a new feature, is failing with a timeout Error. Is some one facing the same? How can this be resolved? Unfortunately I don't see any documentation about this feature as well. Can some one please help me out.
Sample Screenshot :
Regards,
Shahroz
+49-15146933535
Same issue, was this ever fixed?
same problem 😞
I am facing the same issue with Oracle DB.
We were also facing same issue, We were trying to execute select sequence.nextval from dual in a power automate flow and sometimes it takes more than 5 mins with multiple retries. The only solution we came up is to execute the flow at landing page or on the App start, It take a while to load the App but after that it's okay
Sorry for opening an old thread. I am also struggling with this. When I fetch a table it works. If I try to execute a query (for example select systime from dual) I get the badgateway error. The gateway was updated today to latest version. I have read the instructions referred to over.
Any help will be received with thanks!
If it helps anyone...the important piece is that the query times out after 110 seconds, so you'll never get all the records. It this is incorrect, feel free to correct and help out with a workaround.
I have the same issue. Any help appreciated.
Can you share the Flow details (FlowId, RunId, etc) with us so that we can take a look on our side? One more limitation is that the stored procedure needs to return within 110 seconds or so otherwise the action will time out. This limitation is mentioned in the link that Katrina shared above.
Did you ever get an answer to this? I am having the same issue and meet all the requirements suggested by @katwan
There are limitations to use Oracle connector and this feature (https://docs.microsoft.com/en-us/connectors/oracle/#known-issues-and-limitations). Please make sure you have met all these requirements.