Return
-
Title
Running select statement with newline leads to error "ORA-00900: invalid SQL statement" -
Description
In v7.0.1, when you run the statement:
select *
from table
where ID in (1, 2, 3
)
/
You see the error:
ORA-00900: invalid SQL statementAlso, the error "ORA-009007: missing right parenthesis" has been seen.
When you run the statement:
select *
from table
where ID in (1, 2, 3
)
/
(please note the extra space in line 4) it runs successfully.
The statement fails if it has the '/' at the end of the script, however both these statements run in SQL*Plus and SQL Navigator 6.7.1 ok. -
Resolution
WORKAROUND:
Run the statement in v6.7, or in SQL*Plus.
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle -
Defect ID
SQLNAV-651 -
Additional Information
This issue will be fixed in the v7.1 release, due in July 2014