SPARQL 1.1 Property Path Support In SEM_MATCH (Doc ID 1601140.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

Executing this SEM_MATCH query from sqlplus:


select  volumeuri , mappinguri
from table(sem_match(
'
PREFIX rdf:   <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs:  <http://www.w3.org/2000/01/rdf-schema#>
PREFIX san: <http://www.jpmchase.net/owl/ontologies/san/#>
SELECT  ?volumeuri ?mappinguri
WHERE
{
?volumeuri (san:hasMappings)+ ?mappinguri
}
'
,sem_models('san_onco'),null,
null, null));

ORA-29532: Java call terminated by uncaught Java exception: oracle.spatial.rdf.server.ParseException: Encountered "(" at line 8, column 12.
Was expecting one of:
   "a" ...
   "<URI>" ...
   <QNAME> ...
   <VAR> ...
   
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 244
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 178
ORA-06512: at line 4

We tried without the parenthesis in (san:hasMappings)+ but same error using 11.2.0.3.

It works in Oracle 12c.

In the documentation we see example using Java but not with SQLPlus. See 7.5.1
http://docs.oracle.com/cd/E11882_01/appdev.112/e25609/sem_jena.htm#CBBBEBEB

The documentation is unclear for 11.2.0.3.  
The question is whether 11.2.0.3 supports SPARQL 1.1 property path via SQLPLUS.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms