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

5 REPLIES 5
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

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
Frequent Visitor

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. 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors
Users online (1,995)