PDA

View Full Version : Pass Oracle hints into a Power Query



kkalomiris
2017-09-04, 03:43 PM
Hello,
do you know how I can pass Oracle hints, produced from trace plan, into a power query?
When I copy-paste the original code, which is executed thru SQL developer, it gives me an error when it tries to parse the oracle hints part.
A print screen of the error is attached.

Thank you

Bob Phillips
2017-09-04, 04:08 PM
Your SQL text is a string within quotes, and you have quotes within that. Maybe try using single quotes within the string, or double-up on the embedded quotes.