- This topic has 3 replies, 3 voices, and was last updated 16 years, 6 months ago by
.
-
Posts
-
following this thread:
https://www.genuitec.com/forums/topic/oracle-edit-table-data-3-8-3ga/#post-221411i am using MyEclipse 5.0, eclipse 3.2.1 and Oracle 10G and have tables using FLOAT. Oracle specifies that i should not set the scale on the float. but when i don’t and try to edit the table i get the invalid scale size error.
it only works if i change these FLOAT fields to NUMBER(38,5) or something similar.
how can i bridge the gap between these two?
Thanks
YaronOracle specifies that i should not set the scale on the float. but when i don’t and try to edit the table i get the invalid scale size error.
Can you please point me to the documentation that you are referring to.
http://www.ss64.com/orasyntax/datatypes.html
:For floating point don’t specify p,s”also
http://www-eleves-isia.cma.fr/documentation/OracleDoc/NUMBER-DATATYPE.html“NUMBER
is a floating point number with precision 38. Note that a scale
value is not applicable for floating point numbers. “Yaron,
We fixed a number issues in this department in the 5.5 release, I know there was a specific fix for the scale issue as well.
I would recommend upgrading to 6.0.1 and trying again. If the problem still persists, please let us know. Please include the exact Oracle AND Oracle driver versions you are using.
Hope this helps.
