ORA-00933: SQL command not properly ended SEM_APIS.MERGE_MODELS Fails When Comma Is Decimal Symbol In Session

(Doc ID 2013045.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

SEM_APIS.MERGE_MODELS fails when comma is the decimal symbol in my session


ALTER SESSION SET NLS_NUMERIC_CHARACTERS=',.';

EXECUTE SEM_APIS.MERGE_MODELS('PDC_PIP_0000000381' , 'PDC_PIP_0000000381_P')

ORA-00933: SQL command not properly ended
ORA-06512: ved "MDSYS.SDO_RDF", line 4671
ORA-06512: ved "MDSYS.RDF_APIS", line 1389
ORA-06512: ved line 1
00933. 00000 - "SQL command not properly ended"

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