SPARQL Federated Query using SEM_MATCH Fails With Ora-6502 (Doc ID 2474955.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

SPARQL federated query fails with ora-6502 (SEM_MATCH)

select geobyg_id, o,o1,o2,o3,f,p1,p2,p3
from table(sem_match(
'PREFIX AA: <http://<host>/<path>/>
PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#midtier_cache>
SELECT *
WHERE {
  SERVICE <http://<host>/<path>> {
  SELECT * WHERE { ?f ?p1 ?o1 .
  ?f AA:hasBBR ?o}
  }
  SERVICE <http://<host>/<path>> {
  SELECT * WHERE { ?geobyg_id ?p2 ?o2 .
  ?geobyg_id AA:relatestoBBR ?o }
  }
  SERVICE <http://<host>/<path>> {
  SELECT * WHERE { ?x ?p3 ?o3 .
  ?x AA:refersTo ?geobyg_id }
  }
}'
,sem_models('dummy')
,null,null,null,null
,' '));


Error:
ORA-20000: Error in SPARQL SERVICE:
ORA-20000: Error reading
ORA-06502: PL/SQL: numerisk fejl eller værdifejl: character string buffer too small
ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 1126
ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 1136
ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 561
ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 1054

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.