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