2 Replies Latest reply on Jan 24, 2008 4:39 PM by 618501

    Trouble inserting triple

    618501
      I am running through the examples in the Semantic Technologies Developer's Guide, and I am encountering an error. Be aware that I am extremely new to database work, so I am possibly just missing a simple step. Here is what I have done so far:

      - installed the Personal Edition of Oracle 11g
      - performed the step in section 1.10 (although I wasn't sure what the "comp_file" variable was about)
      - performed the steps in section 1.8

      I am now trying to do the first step in section 1.9, which is
      INSERT INTO articles_rdf_data VALUES (1,
      SDO_RDF_TRIPLE_S ('articles','http://www.nature.com/nature/Article1',
      'http://purl.org/dc/elements/1.1/title','All about XYZ'));

      My error in SQL Plus is:
      ERROR at line 1:
      ORA-04063: package body "MDSYS.RDF_APIS_INTERNAL" has errors
      ORA-06508: PL/SQL: could not find program unit being called:
      "MDSYS.RDF_APIS_INTERNAL"
      ORA-06512: at "MDSYS.ARTICLES_DML", line 5
      ORA-04088: error during execution of trigger 'MDSYS.ARTICLES_DML'

      I am not sure what this error means. I am attempting this step as a basic user that I created. Am I missing some privilege? Any help that you can provide will be appreciated.

      Thanks,
      Joe