2 Replies Latest reply on Feb 10, 2011 11:03 PM by alwu-Oracle

    orardf:textContains

    838562
      I'm trying to filter my query with: FILTER ( (orardf:textContains (?x,"MyText" ) || !BOUND(?x )) ) }
      and in response , I receive : "oraclse.spatial.rdf.server.TypeException: Use of user-defined functions in SPARQL filter expressions is not yet supported."

      I'm using oracle 6.2 version and fallowed extractions for full text index at : http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sdo_rdf_concepts.htm#CIHIHAAE

      This is the index:

      SQL> select index_name, index_type,status from dba_indexes where index_name like
      '%TEXT_IDX';

      INDEX_NAME INDEX_TYPE STATUS
      ------------------------------ --------------------------- --------
      RDF_V$TEXT_IDX DOMAIN VALID
      SUP_TEXT_IDX DOMAIN VALID

      SQL>


      what did I do wrong?
        • 1. Re: orardf:textContains
          Matperry-Oracle
          Hi,

          The orardf:textContains filter function was available starting with release 11.2.0.2.0. Previous versions will generate the error message you saw.

          11.2.0.2.0 is available as a patch set for Oracle Database Server that can be downloaded through My Oracle Support.
          Linux, Windows and Solaris versions of the patch set are all available.

          Thanks,
          Matt
          • 2. Re: orardf:textContains
            alwu-Oracle
            Hi,

            There is an alternative if you are using Jena Adapter.

            Pragma specification ORACLE_SEM_UEAP_NS (you can search for it in the following dev guide) can help you here.

            http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sem_jena.htm
            or
            https://students.kiv.zcu.cz/doc/oracle/appdev.112/e11828/sem_jena.htm

            Basically, you URL encode this expression contains(x$_prefix,'MyText')>0 in that namespace specification.
            It will become part of the query.

            In this case, the URL encoded expression is
            contains(x%24_prefix%2C'MyText')%3E0

            Hope it helps,

            Zhe