Getting an error "ORA-00911: invalid character" when using a semicolon in a query with comment and using the Shift + F9 or Execute Snippet.
For example:
Select sysdate from dual; -- get current date
Shift + F9 will error out.
WORKAROUND 1:
If you remove the semicolon it work.
WORKAROUND 2:
If you select all text except the semicolon and hit shift + F9 it work.
WORKAROUND 3:
If you remove the comment it work.
WORKAROUND 3:
If you hit just F9 it work.
STATUS:
Waiting for fix in future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center