My Oracle Support Banner

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 APRIL 04, 2019

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

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
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.