Error ORA-07445 When Performing INSERT ALL On SEM_MATCH Result (Doc ID 1636661.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

When INSERT ALL using a SELECT FROM a SEM_MATCH generating error

  ORA-07445: exception encountered: core dump [kokbTabFuncRewrite()+1215]

This is the code that reproduces the error

conn / as sysdba

@?/md/admin/catsem

CREATE TABLESPACE rdf_tblspace
 DATAFILE 'C:\APP\ORACLE12C\ORADATA\BLUE12\RDF_TBLSPACE.DAT' SIZE 64M REUSE
 AUTOEXTEND ON NEXT 64M MAXSIZE UNLIMITED
 SEGMENT SPACE MANAGEMENT AUTO;

EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');

create user c##sdobug identified by sdobug;
grant connect, resource, dba to c##sdobug;

conn c##sdobug/sdobug

EXECUTE sem_apis.drop_sem_model('sparql_insert');
drop table sparql_insert_staging_table;

CREATE TABLE sparql_insert_staging_table (
RDF$STC_sub varchar2(4000) not null,
RDF$STC_pred varchar2(4000) not null,
RDF$STC_obj varchar2(4000) not null,
RDF$STC_graph varchar2(4000)
);

CREATE TABLE sparql_insert_tpl (triple SDO_RDF_TRIPLE_S);

EXECUTE sem_apis.create_sem_model('sparql_insert', 'sparql_insert_tpl', 'triple');

INSERT ALL
INTO sparql_insert_staging_table VALUES(
 '',
 '',
 '',
 NULL
)
INTO sparql_insert_staging_table VALUES(
 '',
 '',
 '',
 NULL
)
SELECT *
FROM TABLE(SEM_MATCH(
 'SELECT *
  WHERE
  {
   .
  }',
 SEM_Models('sparql_insert'),
 NULL,
 NULL,
 NULL
));


/*
INSERT ALL
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 23021
Session ID: 191 Serial number: 5
*/

Cause

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