2 Replies Latest reply on Oct 25, 2010 3:31 PM by 792262

    error while trying to use '{' in the query

    792262
      Hi,

      The below mentioned query is giving Error while trying to use '{'

      Query:

      select s,x from table(SEM_MATCH(
      '{?s rdf:type <http://www.cs.com/sbip/dwh/mdm/data_modeling#Base_Term> .
      ?s ?p ?x}',
      SEM_Models('foundation'),
      SEM_RuleBases('OWLPRIME'),
      SEM_ALIASES(SEM_ALIAS('dm','http://www.cs.com/sbip/dwh/mdm/data_modeling#'),
      SEM_ALIAS('owl','http://www.w3.org/2002/07/owl#')), null, 'INVALID'))
      where regexp_like(x,'Customers','i');

      Error details:

      ORA-29532: Java call terminated by uncaught Java exception: oracle.spatial.rdf.server.TokenMgrError: Lexical error at line 1, column 1. Encountered: "{" (123), after : ""
      ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 178
      ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 67
      ORA-06512: at line 4

      I am unable to use Option, Filter in query.

      Any solution?

      Please let me know do i need to apply any patch?

      Note: I am using Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

      Regards,
      Kavitha.