Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Christian I was able to get it to work per my earlier post today (using the line EXECUTE PHYSICAL CONNECTION POOL where you would normally type in the logical SQL). I'm not sure if my technical counterparts have configured some custom setup to allow me to do this. -Paul
-
I'm using version 11.1.1.7
-
We have gotten Physical SQL to work in prompts by putting the following into the "SQL results" box in the prompt options: EXECUTE PHYSICAL CONNECTION POOL "[Insert Pool Name within the quotes here]" [Insert Physical SQL here] For example: EXECUTE PHYSICAL CONNECTION POOL "[Insert Pool Name within the quotes here]" [Insert…