Toad World® Forums

Unable to run "with data " using TOAD 12

Hallo:

I’ve been using Toad 11. Just now I’ve update to 12.10.0.30.

I create complex sentences for select using “with” Now they don’t work in “sql editor” (work inside plsql packages).

Easy example:

with
X as (select * from dual)


select * from X;

This sentence run on other products (and Toad 11.x), but not now, after installing Toad 12.

When try to run, I receive this error:

ORA-00928: falta la palabra clave SELECT

Any suggestion?

Thanks

There is a new option introduced in 12.9 or 12.10 that is interfering. In Options on the Execute/Compile page disable “Treat blank line as statement terminator” and the behavior will return to what you are used to.

Michael

That damn option was plaguing me as well! It’s okay to introduce new options, but to set them by default thus changing past behavior??

Thanks for this fix.

Thanks

Now it works.