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

    yenier

      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

      FROM TABLE(SEM_MATCH(

      '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,

       

      Yenier