TOAD 12 crashing on numeric input with multiple decimal points

Hi folks,

I have a teeth grinder verified to occur in 12.0 and 12.1 64 bit. Using 11gR2 64 bit Oracle client on 64 bit Windows 7.

The problem makes repetitive copy and pasting of numeric values onerous.

First open notepad and type “1.1” and copy the text.

Then open any table in the schema browser and set your cursor into a number field. Paste it once and then (yes too much coffee) accidentally paste it a second time forcing “1.11.1” into the field.

TOAD then goes into a death spiral of OCI error popups from which there is no escape short of forcing TOAD closed with the task manager.

I also checked that this occurs when you just type “1.11.1” into a numeric field.

Cheers,

Paul

Hi Paul, can you tell me the data type, precision, and scale of this column?

Thanks,

Brad

From: Paul Dziemiela [mailto:bounce-pdziemiela_781@toadworld.com]

Sent: Friday, September 27, 2013 9:41 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] TOAD 12 crashing on numeric input with multiple decimal points

TOAD 12 crashing on numeric input with multiple decimal points

Thread created by Paul Dziemiela

Hi folks,

I have a teeth grinder verified to occur in 12.0 and 12.1 64 bit. Using 11gR2 64 bit Oracle client on 64 bit Windows 7.

The problem makes repetitive copy and pasting of numeric values onerous.

First open notepad and type “1.1” and copy the text.

Then open any table in the schema browser and set your cursor into a number field. Paste it once and then (yes too much coffee) accidentally paste it a second time forcing “1.11.1” into the
field.

TOAD then goes into a death spiral of OCI error popups from which there is no escape short of forcing TOAD closed with the task manager.

I also checked that this occurs when you just type “1.11.1” into a numeric field.

Cheers,

Paul

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Hi Brad,

Just a plain vanilla NUMBER no precision or scale. I just ntoiced that the problem only occurs for EXISTING rows, it does not occur for a brand new row that has not yet been committed.

So create a new row in a table and commit the row. Then type “1.11.1” into the number field.

I get the error “OCI-22060: argument[2] is an invalid or uninitialized number” over and over in an unending sequence of pop up windows. There is no escape.

Paul

I’ve got the same column and Toad won’t let me paste in a second “1.1”. There was a change in 12.0.1 patch that addressed a similar issue. Are you running
the latest 12.0.1 patch?

From: Paul Dziemiela [mailto:bounce-pdziemiela_781@toadworld.com]

Sent: Friday, September 27, 2013 10:48 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] TOAD 12 crashing on numeric input with multiple decimal points

RE: TOAD 12 crashing on numeric input with multiple decimal points

Reply by Paul Dziemiela

Hi Brad,

Just a plain vanilla NUMBER no precision or scale. I just ntoiced that the problem only occurs for EXISTING rows, it does not occur for a brand new row that has not yet been committed.

So create a new row in a table and commit the row. Then type “1.11.1” into the number field.

I get the error “OCI-22060: argument[2] is an invalid or uninitialized number” over and over in an unending sequence of pop up windows. There is no escape.

Paul

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

No but I downloaded 12.1 today to see if by chance that fixed it and no such luck.

Cheers,

Paul

I just tried the same thing in 12.1 and got no error. Here are my steps:

Open editor, type create table junk (c1 number); and execute – table created.

Open schema browser, tables, focus on junk, press + toolbar to create row, try to enter 1.11.1 and on second period toad makes noise and won’t allow second
period

From: Paul Dziemiela [mailto:bounce-pdziemiela_781@toadworld.com]

Sent: Friday, September 27, 2013 10:05 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] TOAD 12 crashing on numeric input with multiple decimal points

RE: TOAD 12 crashing on numeric input with multiple decimal points

Reply by Paul Dziemiela

No but I downloaded 12.1 today to see if by chance that fixed it and no such luck.

Cheers,

Paul

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

After you create the table, focus on junk and type “1” and then COMMIT. After that then focus back on the same row and type “1.1.1”. That is when it happens to me.

Cheers,

Paul

Nope – same behavior. Enter the 1 and commit. Go back to that row and try to replace with 1.11.1 and it beeps – won’t do it

From: Paul Dziemiela [mailto:bounce-pdziemiela_781@toadworld.com]

Sent: Friday, September 27, 2013 10:10 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] TOAD 12 crashing on numeric input with multiple decimal points

RE: TOAD 12 crashing on numeric input with multiple decimal points

Reply by Paul Dziemiela

After you create the table, focus on junk and type “1” and then COMMIT. After that then focus back on the same row and type “1.1.1”. That is when it happens to me.

Cheers,

Paul

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Try pasting instead of typing.

From: Bert Scalzo [mailto:bounce-Bert_Scalzo@toadworld.com]

Sent: Friday, September 27, 2013 10:13 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] TOAD 12 crashing on numeric input with multiple decimal points

RE: TOAD 12 crashing on numeric input with multiple decimal points

Reply by Bert Scalzo

Nope – same behavior. Enter the 1 and commit. Go back to that row and try to replace with 1.11.1 and it beeps – won’t do it

From: Paul Dziemiela [mailto:bounce-pdziemiela_781@toadworld.com]

Sent: Friday, September 27, 2013 10:10 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] TOAD 12 crashing on numeric input with multiple decimal points

RE: TOAD 12 crashing on numeric input with multiple decimal points

Reply by Paul Dziemiela

After you create the table, focus on junk and type “1” and then COMMIT. After that then focus back on the same row and type “1.1.1”. That is when it happens to me.

Cheers,

Paul

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Bummer,

Well nothing to do but avoid double pasting. Thanks for your time.

Cheers,

Paul

TOAD HEAL THYSELF

Just to close out this thread in case anyone else has the issue.

Last week I had some interoffice musical chairs take place which resulting in my office manager needing to change my work location on short notice. This involved yanking the plug on my machine to expedite the move (i was not present at the time I should add). Anyhow as I had TOAD open at the time this hosed all the TOAD settings and when I restarted I ended up with a corruption message and then the fresh factory default settings.

So while I lost all my connections and configurations, the upside is the above number problem has gone away!

Now things work as Bert and John say. I am thinking the old settings might dated back originally to TOAD 8 and just been migrated with each version.

In short if you have odd data entry problems, try resetting things to the factory default.

Now if I could just get the data grid to look like it used to…

Cheers,

Paul