My Oracle Support Banner

Insert ALL Into ORA-00932: Inconsistent Datatypes: Expected UDT Got BINARY (Doc ID 1621454.1)

Last updated on APRIL 04, 2019

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 "INSERT ALL" is needed in order 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
"INSERT ALL" query pattern is needed to insert more than one triple per row in the SEM_MATCH table.

Changes

 

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
Changes
Cause
Solution
References


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