Toad World® Forums

Bug in New toad version compare to very old version

There are some weird things going on in SQL*Plus with it, so you can see it's not Toad. The sample below is with uniqueid varchar2(5).

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Thu May 30 2019 07:27:02 -05:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

SQL> SELECT a.street.city.region.uniqueid FROM vw_address a;

STREET.CIT
----------
HARRIS

SQL> select deref(region) from vw_city;
select deref(region) from vw_city
*
ERROR at line 1:
ORA-22814: attribute or element value is larger than specified in type

Ok are you suppressing this when I click on reference column? Ideally toad should throw error same as you have mentioned above.

Oh, no, I didn't mean to imply that, sorry. I'm not suppressing anything in Toad.

We give Oracle the same query that you type into Toad....I just saw this error and deref and wanted to point it out.

if you run the query with deref in Toad, you'll get the same error.

Thats is what I wanted to say if I click on that cell instate showing empty window cant we throw error on UI so that user will know.

That query with deref isn't run in Toad. The query that Toad runs just selects the fields without deref, and there isn't any error. If Oracle gave an error, we'd throw it...but we don't get one, we just get null.