3 Replies Latest reply on Feb 7, 2011 5:01 PM by Matperry-Oracle

    How to create a normal view from the RDF sparql query?

    792262
      Hi,

      I am trying to create a view from the below query.

      select id, name from table(SEM_MATCH('
      (?id rdf:type dm:Conceptual_SMA_Information_Group)
      (?id dm:hasConceptualSmaInformationGroupName ?name)',
      SEM_Models('nyc_sma_curr'), null,
      SEM_ALIASES(SEM_ALIAS('dm','http://www.cdse.com/sbip/dwh/mdm/data_modeling#')), null))
      order by name,id;

      I am trying the below syntax to create a viewa but its giving the error and m unable to create view.

      create view Information_Group as
      select id, name from table(SEM_MATCH('
      (?id rdf:type dm:Conceptual_SMA_Information_Group)
      (?id dm:hasConceptualSmaInformationGroupName ?name)',
      SEM_Models('nyc_sma_curr'), null,
      SEM_ALIASES(SEM_ALIAS('dm','http://www.cdse.com/sbip/dwh/mdm/data_modeling#')), null))
      order by name,id;

      Error: ORA-00600: internal error code, arguments: [17046], [0x46E62D720], [0x46F2485F0], [1], [], [], [], [], [], [], [], []

      Please help me to create a view.

      Let me know if you need more details.

      Regards,
      Kavitha.