1 Reply Latest reply on Jan 17, 2008 11:47 PM by Mannamal-Oracle

    Problem with NLS support in RDF 10.2.0.3 and SEM in 11g?

    68458
      I`m trying to insert this triple from family example into Oracle 10.2.0.3:

      INSERT INTO family_rdf_data VALUES (30,
      SDO_RDF_TRIPLE_S('family',
      'http://www.example.org/family/Cathy',
      'http://www.example.org/family/height',
      '"5.8"^^xsd:decimal'));
      and get the following error:

      ERROR en lÝnea 2:
      ORA-13199: RDF:Error occurred -13199, ORA-13199: RDF:Object not parsed -6502,
      ORA-06502: PL/SQL: error : error de conversi¾n de carßcter a n·mero numÚrico o
      de valor
      ORA-06512: en "MDSYS.MD", lÝnea 1723
      ORA-06512: en "MDSYS.MDERR", lÝnea 17
      ORA-06512: en "MDSYS.SDO_RDF_TRIPLE_S", lÝnea 109

      The NLS parameters for my DB are:

      nls_language="SPANISH"
      nls_length_semantics=BYTE
      nls_territory="SPAIN"

      If I change the dot in 5.8 of '"5.8"^^xsd:decimal' by a comma like this: "5,8"^^xsd:decimal'
      Oracle acepts the sentence, the problem is that sentences like:


      SELECT m, h
      FROM TABLE(SDO_RDF_MATCH(
      '(?m rdf:type :Male) ( ?m :height ?h )',
      SDO_RDF_Models('family'),
      NULL,
      SDO_RDF_Aliases(SDO_RDF_Alias('','http://www.example.org/family/')),
      '(h >= 6)'
      )
      );

      don't reterieves any tuple, and tuples:
      http://www.example.rg/family/Cindy 6,00
      and
      http://www.example.rg/family/Jack 6

      satify the query

      I have the same problem with Oracle 11g with latest patch for semantic support.
      With my spanish NLS settings I don't achieve latest sentence works
      What I doing wrong?
      Is semantic support sensitive to the use of the dot or comma as decimal separator? Which NLS settings are tested with semantic support?
      Could you give my an example using filter with numerical values that works?


      Thank in advance


      PD (sorry for my english)