Toad World® Forums

Oracle error for divider on separate line

Hi guys,

I've just came across following bug in toad for oracle (v13.2.0.258).

originally I experienced it in a complex statement with a complex formula split into multiple lines.
but I've managed to track it down to this simple case.
divider sign on a separate line causes ORA-923
statement must have been misinterpreted by toad since sqlplus doesn't have a problem with such a formula.
please check.

image

image

image

image

emha.

The TOAD edit window is treating a slash on a line by itself as a command to execute the previous text. You get the error because "select 1" is not a valid SQL statement.

I don't know what the fix, if any, is going to be, but this is why it is happening.

Is is a SQLPlus setting that's allowing that to execute for you? I'm seeing an error here. From SQLPlus can you run show all and provide the output?

This is what I see.

yes, if you type the statement directly in sqlplus, it tries to interpret slash and execute statement.
but if you edit statement in external editor, then it execute without any issue.

emha.