11 Replies Latest reply on Jan 21, 2009 8:33 PM by Mannamal-Oracle

    Creating a normal view on semantic data

    610533
      Hi there.
      I have a semantic database that I would like to expose through some of our other software. The easiest way would be to create a view of the semantic data and point the software to it.

      When i try
      SELECT x, y FROM TABLE(SEM_MATCH( '(?x rdf:type <http://www.w3.org/2002/07/owl#Class>) (?x rdfs:subClassOf ?y)',
      SEM_Models('NBEDATA'),
      null,
      null,
      null));

      I get the results returned, but trying
      create or replace view dataclasses as SELECT x, y FROM TABLE(SEM_MATCH( '(?x rdf:type <http://www.w3.org/2002/07/owl#Class>) (?x rdfs:subClassOf ?y)',
      SEM_Models('NBEDATA'),
      null,
      null,
      null));

      Throws an ora-00600 internal error.
      ORA-00600: internal error code, arguments: [17046], [0x7FFCF4F7AF8], [0x7FFD260DE98], [1], [], [], [], []

      Can you tell me if a view can be created on semantic data and if so how can I do it.

      Cheers

      Phil