Hi John
I have checked all NLS and other settings and I always use comma as a
decimal separator as
it is standard in my region.
Your suggested workaround works fine if I change decimal separator to
dot in my TOAD setting .
I am now waiting for my customer responses because I thing that changing
TOAD setting will also
have an impact on reports and SQL scripts.
Thank you and best regards!
John Bowman wrote:
Hey Aci,
Norm has a very good point. Another thing you can check is your
"Decimal separator" and "Thousand separator" settings in your Toad
options. The basic insert statement you provided with your original post:
INSERT INTO "QUEST"."OW_XX" (
"CUST_ID", "NAME", "ADDRESS", "BALANCE", "CREDIT_LMT",
"OPERATER", "DATPOSEGA"
) VALUES (
215494973,
'gykUUOuwEytdmlocTAsOGVAGUeAiLsXwjVEKAVUQgbgnTnErlfuc', '2842 NW Round
Mountain Vlg',
1264567046891,89, 4702781590167,41, 'XLZCeCPxjhodKGBXTI',
TO_DATE('19-FEB-2078', 'DD-MON-RRRR')
);
suggests you used the Internal random data engine when generating
data. This engine uses the standard Windows locale settings for
numeric / floating point values; however the standard Windows settings
are overridden by the Decimal and Thousand Separator settings in the
Toad options. You can find these settings in Toad Options à General à
Numeric characters. The Internal data generation engine will use
these settings for floating point and currency values when generating
the script.
If you plan on using the internal generator, I would check these
settings and modify them as necessary to correctly handle currency and
floating point values on your machine.
I hope this information helps. Let us know if you continue to run
into issues using this feature!
-John
Hi John
I have checked all NLS and other settings and I always use comma as a decimal
separator as
it is standard in my region.
Your suggested workaround works fine if I change decimal separator to dot in my
TOAD setting .
I am now waiting for my customer responses because I thing that changing TOAD
setting will also
have an impact on reports and SQL scripts.
Thank you and best regards!
John Bowman wrote:
Hey Aci,
Norm has a very good point. Another thing you can check is your
“Decimal separator” and “Thousand separator”
settings in your Toad options. The basic insert statement you provided with
your original post:
INSERT INTO "QUEST"."OW_XX" (
"CUST_ID", "NAME", "ADDRESS", "BALANCE", "CREDIT_LMT", "OPERATER",
"DATPOSEGA"
) VALUES (
215494973, 'gykUUOuwEytdmlocTA sOGVAGUeAiLsXwjV EKAVUQgbgnTnErlf uc', '2842
NW Round Mountain Vlg',
1264567046891, 89, 4702781590167, 41, 'XLZCeCPxjhodKGBXTI ', TO_DATE('19-
FEB-2078' , 'DD-MON-RRRR' )
);
suggests you used the Internal random data engine when generating data. This
engine uses the standard Windows locale settings for numeric / floating
point values; however the standard Windows settings are overridden by the
Decimal and Thousand Separator settings in the Toad options. You can find
these settings in Toad Options à General à Numeric characters. The
Internal data generation engine will use these settings for floating point
and currency values when generating the script.
If you plan on using the internal generator, I would check these settings
and modify them as necessary to correctly handle currency and floating point
values on your machine.
I hope this information helps. Let us know if you continue to run into
issues using this feature!
-John
Attachment not added (content type not allowed): "acip.vcf"
