xs:decimal type mapping with fractiondigits
Hello,
if XML-Schema defines an element as
<xs:simpleType>
<xs:restriction base="xs:decimal">
<xs:totalDigits value="20"/>
<xs:fractionDigits value="18"/>
</xs:restriction>
</xs:simpleType>
then Oracle creates an object type with an attribute NUMBER(20,18).
That does not allow to store numbers with e.g. three or more digits on pre-decimal places but without digits on decimal places.
That would be on the other hand allowed in XML document, would it?
Would annotating the schema with SQLTypeMapping to e.g. float help here?
Is there any other workaround to this?
Thanks,
Andrej
Edited by: user12140249 on 10.11.2009 14:26