ORA-00904 Invalid Identifier While Running a SEM_MATCH Query (Doc ID 1459558.1)

Last updated on JANUARY 12, 2020

Applies to:

Symptoms

Migrated from 11.2.0.1 to 11.2.0.3

After the migration the following query results in ORA-904

select title
from table(sem_match('{
?s ?title .
}',
sem_Models('articles2'),
null,null,null))
/

ERROR at line 1:
ORA-00904: "title": invalid identifier

Can reproduce by running the following in the migrated database

CREATE TABLE articles_rdf_data2 (id NUMBER, triple SDO_RDF_TRIPLE_S);
EXECUTE SEM_APIS.CREATE_RDF_MODEL('articles2', 'articles_rdf_data2', 'triple');
INSERT INTO articles_rdf_data2 VALUES (1,
SDO_RDF_TRIPLE_S ('articles2','http://nature.example.com/Article1',
  'http://purl.org/dc/elements/1.1/title','All about XYZ'));
INSERT INTO articles_rdf_data2 VALUES (2,
SDO_RDF_TRIPLE_S ('articles2','http://nature.example.com/Article1',
  'http://purl.org/dc/elements/1.1/creator',
  'Jane Smith'));
INSERT INTO articles_rdf_data2 VALUES (3,
SDO_RDF_TRIPLE_S ('articles2',
  'http://nature.example.com/Article1',
  'http://purl.org/dc/terms/references',
  'http://nature.example.com/Article2'));
INSERT INTO articles_rdf_data2 VALUES (4,
SDO_RDF_TRIPLE_S ('articles2',
  'http://nature.example.com/Article1',
  'http://purl.org/dc/terms/references',
  'http://nature.example.com/Article3'));
INSERT INTO articles_rdf_data2 VALUES (5,
SDO_RDF_TRIPLE_S ('articles2',
  'http://nature.example.com/Article2',
  'http://purl.org/dc/elements/1.1/title',
  'A review of ABC'));
INSERT INTO articles_rdf_data2 VALUES (6,
SDO_RDF_TRIPLE_S ('articles2',
  'http://nature.example.com/Article2',
  'http://purl.org/dc/elements/1.1/creator',
  'Joe Bloggs'));
INSERT INTO articles_rdf_data2 VALUES (7,
SDO_RDF_TRIPLE_S ('articles2',
  'http://nature.example.com/Article2',
  'http://purl.org/dc/terms/references',
  'http://nature.example.com/Article3'));
COMMIT;


select title
from table(sem_match('{
?s ?title .
}',
sem_Models('articles2'),
null,null,null))
/

ERROR at line 1:
ORA-00904: "title": invalid identifier

Cause

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