I'm trying to insert (amongst other things) a decimal value from an XML file into a NUMBER column (where the precision and scale are unspecified) in an Oracle 8.1.7 database, but am having little joy - I get a java.lang.NumberFormatException.

I can manually insert this value into the DB. Does anyone know how I can get round this problem, or what I might be doing wrong?

I know XML in Oracle 8i is not great, but any help would be greatly appreciated.