Toad World® Forums

Editor - incorrectly reporting syntax error "Unbalanced string literal"


#1

Hi,

In 12.7.0.49, I noticed that I was getting a syntax error reported after I typed a very simple select statement: “ERROR: line X, column Y: Unbalanced string literal near end of chunk”. This error remains, even after you have completed the statement, and it runs successfully. Any chance it could be fixed, please?

toad_unbalanced_string_lit.jpeg


#2

Either my email was blocked or heavily delayed. Ain’t nobody got time for that. Re-posting.

I’ve seen this several times, but haven’t tracked down the cause yet. I think that the parser data is still good so execution should carry on as expected, but you can force a full refresh of errors an parser data by clicking the refresh button on the navigator. It’s on my todo list.


#3

Yeah, execution continues as expected.

Have just done something similar in 12.6, and the error occurs there, although all we see is a red squiggly line under the “c” of the first line (create table …). Looks like the issue has been there for a while, but it’s now much more obvious!