Skip to main content

Notifications

Power Automate - Using Connectors
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.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics