RE: bad number OCI death spiral?

I can only type in one negative sign.  For me, Toad is just ignoring the 2nd one.  I tried this in Editor and SB.  How are you getting that 2nd one in there?

From: [email protected] [mailto:[email protected]] On Behalf Of Paul Dziemiela
Sent: Thursday, May 31, 2012 7:28 AM
To: [email protected]
Subject: [toad] bad number OCI death spiral?


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