14 Replies Latest reply on Jun 5, 2017 7:41 PM by Matperry-Oracle

    Error executing a SEM_MATCH query with the operator orardf:textScore


      Dear all:


      I am using Oracle 12c Release 2 and I need to execute a SEM_MATCH query with the operators orardf:textContains and orardf:textScore.


      I executed the Example Query 1-78 orardf:textScore that appears in the documentation (https://docs.oracle.com/database/122/RDFRM/rdf-semantic-graph-overview.htm#RDFRM185), see the query below:

      SELECT x, y, n, scr


      'SELECT *

      WHERE {

        { SELECT ?x ?y ?n (orardf:textScore(123) AS ?scr)

          WHERE {

            ?x :grandParentOf ?y .

            ?x rdf:type :Male .

            ?x :name ?n

           FILTER (orardf:textContains(?n, " A% | B% ", 123)) } }

        FILTER (?scr > 0.5) }',

      SEM_Models('myModel'),  null, null, null, null, ' REWRITE=F '));

      It returns the following error:


      ORA-09999: Message 9999 not found;  product=RDBMS; facility=ORA

      Does anyone have an idea of what is going on?


      Thank you,