[16.3.60.1870] Edit statement does not show results/receives error

Toad for Oracle - Beta
1

Hi,

in the official Toad 16.2 and in the latest Beta version 16.3.60.1870 i am facing the issue that an edit statement does not show a result.

The following select statement shows this result:

select * from sql where sql_id = 1086001;

image
image699×141 10.4 KB

Error case:
When i use an edit statement without ";" at the end, there will be no result shown!

edit sql where sql_id = 1086001

image

And an edit statement without any where clause or ";" at the end is throwing following exception "[Error] Execution (1: 1): ORA-00936: missing expression":

edit sql

image

This error can be reproduced on multiple users and clients!

BR, Julian

2

Sorry about that. I'll investigate. It probably happened when we made the EDIT command support multi-line. So now you can do

edit table
where sql_id = 8675309
and name = 'JENNY'
order by 1;

3

I think the problem is largely due to the fact that your table name, SQL, is a pl/sql reserved word.

It works fine if your table is named SQLS, for example.

if you can't or don't want to rename it, then you can work around it with double-quotes around the table name:

edit "SQL"

4

I fixed it to support any keyword. (QP-4022)
To show up soon.

Andre

2 Likes
5

Thanks!
BR, Julian