web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Oracle Database Execut...
Power Automate
Unanswered

Oracle Database ExecutePassThroughQuery has no dynamic output when scoped in 'apply to each' block

(0) ShareShare
ReportReport
Posted on by

Have been double checking to make sure and I can't find any other reason why this error is ocurring.

 

If I have an Execute a Oracle Query action at the top level it outputs a dynamic resultsets output as shown:

mattfabbvie_0-1677627346475.png

 

However if I use an apply to to send multiple requests, the execute query no longer supplies a dynamic result and I essentially cannot use it at all (I can't show the full scroll down in the image but it is not present in the full list and also when searching to override type checking). even though I can verify the same output is coming out of it in test runs:

 

mattfabbvie_1-1677627782852.png

 

 

Is this intended behavior or a glitch? and if this is intended behavior is there a reason for it from Microsoft and is there a fix? it does not seem to be documented in their listed limitations of the queries:

 

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.
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard