Insert ALL Into ORA-00932: Inconsistent Datatypes: Expected UDT Got BINARY (Doc ID 1621454.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

INSERT ALL INTO fails with error:

ORA-00932: inconsistent datatypes: expected UDT got BINARY

The INSERT INTO (Without ALL) works but customer needs "INSERT ALL" query pattern because they need to insert more than one triple per row in the SEM_MATCH table.

Code:

INSERT ALL INTO ora_00932_tpl(triple)
SELECT SDO_RDF_TRIPLE_S('ora_00932', '', '', '') AS triple FROM DUAL;
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected UDT got BINARY
I need the "INSERT ALL" query pattern because I need to insert more than one triple per row in the SEM_MATCH table.

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