Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01745 when running Explain Plan

PaoloMMay 29 2012 — edited Jul 10 2012
Hello everybody,
I would like to know what is the best way to report a bug. In fact I believe just found one and I would like it fixed. I am using the latest version of SQLDeveloper on WinXP that uses its own JDK.

To replicate the bug it's very easy, just try to do an explain plan of the following query:
SELECT * FROM scott.emp 
where empno = &&emp_nr;
and the "*ORA-01745: invalid host/bind variable name*" error appears. Since the query executes properly, but the Explain plan errors out, I believe this could be a bug.

Thanks,
Paolo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2012
Added on May 29 2012
5 comments
1,491 views