Error when executing a sql statement which does not have closed single quote in the end (4334283)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error when executing a sql statement which does not have closed single quote in the end
Description

Error when executing a sql statement which does not have closed single quote in the end.
When you execute the query below:

select * from v$session where username like 'SYS%

You get an " List index out of bounds." error.
SQL Navigator should return an "ORA-01756: quoted string not properly terminated" instead
Resolution

WORKAROUND

None

STATUS

Waiting for fix in a future release of SQL Navigator for Oracle
Defect ID

SQLNAV-1378

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title