bad number OCI death spiral?

Paul Dziemiela <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <93E6FC4F2C85054AA824949283899D2EB191C307DD@HW3SP-EXCHQ1.induscorp.com>
Hi folks,

Using TOAD 11.5.0.56.

I've noticed some rather unfortunate behavior when editing numbers in the data grid.

I just create a table with a number column:

CREATE TABLE foo1 (
yada NUMBER
);

Then open that table in the data grid and start plugging in numbers, say 10, 20, 30 and commit.  If I then do something dumb, say I erroneously enter the number "-10" over the original 10 with two negative signs, Toad responds with:

OCI-22062:invalid input string [-

This seems reasonable enough, my input was indeed the result of too much coffee and not valid.  However at this point I am in the TOAD death spiral and can do nothing but click OK a dozen times till finally I am offered the restart checkbox.  Note this does not occur on a fresh insert, but rather on an update.  A new insert reports the OCI problem, allows you to click OK and then things are fine.

Cheers,

Paul
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.