4 Replies Latest reply on Mar 2, 2011 7:35 AM by 843565

    MDSYS.RDF_MATCH_IMPL_T has errors

    843565
      Hello!

      I am working with Oracle 11.2 g Enterprise Edition (the patch jenadrv-patch111rdf-156996 has been installed successfully).
      I have done some steps to use semantic network as done in Developers Guide:

      CREATE TABLESPACE ...
      EXECUTE SEM_APIS.CREATE_SEM_NETWORK(...

      CREATE TABLE family_rdf_data (id NUMBER, triple SDO_RDF_TRIPLE_S);

      execute SEM_APIS.create_rdf_model('family', 'family_rdf_data', 'triple');

      INSERT INTO family_rdf_data VALUES (1,
      SDO_RDF_TRIPLE_S('family',
      'http://www.example.org/family/John',
      'http://www.example.org/family/fatherOf',
      'http://www.example.org/family/Suzie'));

      INSERT ....

      COMMIT;

      When I try to create rule index:

      BEGIN
      SEM_APIS.CREATE_RULES_INDEX(
      'rdfs_rix_family',
      SEM_Models('family'),
      SEM_Rulebases('RDFS'));
      END;
      /

      the error appears:

      ORA-04063: package body "MDSYS.SDO_SEM_UTL" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "MDSYS.SDO_SEM_UTL"
      ORA-06512: at "MDSYS.RDF_APIS", line 208
      ORA-06512: at line 2

      And when I try to execute a select:

      SELECT m
      FROM TABLE(SEM_MATCH(
      '(?m rdf:type :Male)',
      SEM_Models('family'),
      null,
      SEM_ALIASES(SEM_ALIAS('','http://www.example.org/family/')),
      null));

      the error appears:

      ORA-04063: type body "MDSYS.RDF_MATCH_IMPL_T" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "MDSYS.RDF_MATCH_IMPL_T"
      ORA-06512: at line 4

      May be the patch jenadrv-patch111rdf-156996 is wrong for oracle 11.2 ?

      Thank you