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