cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Oracle Connector - Execute a Oracle Query (Preview) - Bad Gateway Issue

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 :

Shahroz_01_0-1603975435766.png

 

Regards,

Shahroz

+49-15146933535

1 ACCEPTED SOLUTION

Accepted Solutions
katwan
Microsoft
Microsoft

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.

  1. Oracle native query is supported with the following limitations:
    • RefCursor is not supported.
    • OUT parameters are not supported.
    • Only one result set can be returned.
    • Gateway version 3000.63.4 (October release) or later is required.
  2. Minimum supported version for Oracle server is version 9
  3. Minimum supported version for Oracle Data Access Client is version 11

View solution in original post

6 REPLIES 6
katwan
Microsoft
Microsoft

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.

  1. Oracle native query is supported with the following limitations:
    • RefCursor is not supported.
    • OUT parameters are not supported.
    • Only one result set can be returned.
    • Gateway version 3000.63.4 (October release) or later is required.
  2. Minimum supported version for Oracle server is version 9
  3. Minimum supported version for Oracle Data Access Client is version 11
FoDelement
Continued Contributor
Continued Contributor

Did you ever get an answer to this? I am having the same issue and meet all the requirements suggested by @katwan 

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.

oleig
New Member

I have the same issue. Any help appreciated. 

alinapetra
Helper I
Helper I

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. 

pauper
New Member

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!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Kudoed Authors
Users online (3,054)