cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

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

Responsive Resident
Responsive Resident

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.

New Member

I have the same issue. Any help appreciated. 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (22,738)