3 Replies Latest reply on Jun 25, 2007 9:37 PM by Mannamal-Oracle

    problem with SDO_RDF_MATCH filter

    571758
      Hi,
      I've tried to use the SDO_RDF_MATCH filter option in query, but I have got the following errors:

      ORA-01722:
      ORA-06512: at"SYS.DBMS_SYS_SQL", line 1205
      ORA-06512: at"SYS.DBMS_SQL", line 328
      ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 225

      I have tried to do this also on the Oracle example from documentation :

      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)'
      )
      );

      But it is not working, where is my mistake?

      Regards.
        • 1. Re: problem with SDO_RDF_MATCH filter
          Mannamal-Oracle
          Hi,

          This is a known issue with an earlier version (10.2.0.1 or 10.2.0.2). This issue is not there in 10.2.0.3 onwards.

          If you are on 10.2.0.1, I recommend you download the patch from http://www.oracle.com/technology/tech/semantic_technologies/index.html (click on 'software') and apply the patch. This issue should be resolved.

          Melli
          • 2. Re: problem with SDO_RDF_MATCH filter
            584499
            Hi,
            we are working with the following version of oracle:

            Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
            PL/SQL Release 10.2.0.3.0 - Production
            CORE     10.2.0.3.0     Production
            TNS for HPUX: Version 10.2.0.3.0 - Production
            NLSRTL Version 10.2.0.3.0 - Production

            when we try to execute the following query

            select x, kilometraje
            from table (sdo_rdf_match(
            '(?x :Kilometraje ?kilometraje)',
            SDO_RDF_Models('adn'),
            null,
            SDO_RDF_Aliases(SDO_RDF_ALIAS(null,'http://www.wwwww.com/wwwww.owl#')),
            '(kilometraje > 10000)'))

            we get the following error

            ORA-01722: invalid number
            ORA-06512: at "SYS.DBMS_SYS_SQL", line 1209
            ORA-06512: at "SYS.DBMS_SQL", line 328
            ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 235

            do you have any clue???
            Thanks

            Message was edited by:
            user581496
            • 3. Re: problem with SDO_RDF_MATCH filter
              Mannamal-Oracle
              In your case it might have something to do with the NLS_LANG environment variable. What was it set to when you loaded the data?

              Try setting it to the same when you run this query also.

              Melli