This content has been marked as final. Show 3 replies
Check info here Problems with date formats and decimal delimiters
or just try to change dots "." for commas "," in float values:
INSERT INTO rdf_data (id, triple) VALUES (1, SDO_RDF_TRIPLE_S('test', '<http://www.daml.org/2003/01/periodictable/PeriodicTable#N>', '<http://www.daml.org/2003/01/periodictable/PeriodicTable#atomicWeight>', '"14,0067"^^<http://www.w3.org/2001/XMLSchema#float>')) ;
if this works then your locale expects you to provide float values with comma as decimal delimiter.
Thanks, I think the problem was in it. But is there a way to set local columns to float with "." instead of "," for example only specified tablespace? I'm trying to load rdf rules in NTriple form to Oracle RDF data type, but there is a problem with local settings. So the question is can I change database settings or should write ALTER SESSION command in the NTripleConverter Java class ?
Thanks for answer.
Are you wondering how to change the NLS settings during the batch load? I believe this can be done by setting it as an operating system environment variable - for example for linux/unix based systems it can be done as:
%setenv NLS_LANG American
More details are in the documentation Oracle® Database Globalization Support Guide 10g Release 2 (10.2) Part Number B14225-02. (chapter 3 has details on NLS_LANG).
After setting the NLS_LANG variable the batch loader should work according to that setting.
As the documentation describes the setting can also be altered by including ALTER SESSION in the Java class, but setting it as an environment variable should be easier.