1 Reply Latest reply on Aug 27, 2009 3:37 PM by Mannamal-Oracle

    Combining semantic and full-text search causes ORA-03113

    671085
      Hello All

      I am trying to combine a semantic query with a full-text search using a "context" index on a table containing the labels from my rdf resources;
      My query looks like this :

      SELECT s, label
      FROM TABLE(
      SEM_MATCH(
      '
      (?s rdf:type <http://www.chu-rouen.fr/stms#CIM10Bloc>)
      (?s rdfs:label ?label)
      ',
      SEM_Models('rdf_model'),
      null,
      null,
      null,
      null,
      null)
      ), mdc_resource_label
      WHERE
      reslbl_resource = s
      and contains(reslbl_label, 'vih', 1) > 0
      ORDER BY score(1)

      ... and this works great :-)

      BUT what I want to do next is to limit the number of results returned, so I encapsulate the above query in a query filtering the rownum :

      SELECT s, label FROM (
           SELECT s, label, rownum as r
           FROM TABLE(
           SEM_MATCH(
           '
           (?s rdf:type <http://www.chu-rouen.fr/stms#CIM10Bloc>)
           (?s rdfs:label ?label)
           ',
           SEM_Models('rdf_model'),
           null,
           null,
           null,
           null,
           null)
           ), mdc_resource_label
           WHERE
           reslbl_resource = s
           and contains(reslbl_label, 'vih', 1) > 0
           ORDER BY score(1)
      ) a1
      where a1.r <= 5

      and I get the following error :

      where a1.r <= 5
      *
      ERROR at line 21:
      ORA-03113: end-of-file on communication channel

      Any Hint ? my version number below :

      SQL> select * from v$version;

      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
      PL/SQL Release 11.1.0.7.0 - Production
      CORE     11.1.0.7.0     Production
      TNS for Linux: Version 11.1.0.7.0 - Production
      NLSRTL Version 11.1.0.7.0 - Production

      Thanks
      Thomas FRANCART - Mondeca