My Oracle Support Banner

ORA-06592: CASE Not Found While Executing CASE Statement When Running SEM_MATCH Query (Doc ID 1498785.1)

Last updated on JANUARY 15, 2020

Applies to:

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

Symptoms

After migrating from 11.2.0.1 to 11.2.0.3

Any use of Sem_match throws an error on any model

select *
from table(sem_match
  ( '{ ?s ?p ?o }'
  ,sem_models('MODEL1'),
  SEM_RULEBASES(''),
  SEM_ALIASES(SEM_ALIAS(null,'http://www.novartis.com/metastore#'))
  ,null));

ORA-06592: CASE not found while executing CASE statement
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 209
ORA-06512: at line 4

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


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