"Invalid character" when using "?" as parameter in "Explain Plan"
I cannot use "?" while doing Explain Plan. For example, if we do "Explain Plan" on the following
select * from DUAL WHERE DUMMY = ?;
it only returns ORA-00911: invalid character.
Does anyone know how to fix this?
The server output is:
HR> EXPLAIN PLAN SET STATEMENT_ID = 'oj0tgh/14pN9ZXg4J/hA6Q==' INTO "PLAN_TABLE" FOR select * from DUAL where dummy = ?
[2022-11-09 11:42:20] [22019][911] ORA-00911: invalid character
[2022-11-09 11:42:20] Position: 114
Please sign in to leave a comment.
We are reproducing that. We will update the ticket you requested previously: https://intellij-support.jetbrains.com/hc/en-us/community/posts/8487196807826-Cannot-use-in-Explain-Plan