Version of Toad? 32 or 64 bit? Running via F5 or F9?
From: DanCJ [mailto:bounce-DanCJ@toadworld.com]
Sent: Thursday, October 24, 2013 10:48 AM
Subject: [Toad for Oracle - Discussion Forum] Biind variables being truncated to 15 significant figures
Biind variables being truncated to 15 significant figures
Thread created by DanCJ
If I try to run the following query in the editor:
select :a from dual;
And then in the pop-up I set :a to be a number with the value of 1234567890123456789 then the data grid gives me 1234567890123460000.
I have scientific notation turned off, but when I go to re-run the query the bind variable is now set to 1.23456789012346E18.
Selecting 1234567890123456789 directly from dual without using a bind variable works fine.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.