ORA-01756 Quoted String Not Properly Terminated While Validating Transformation Coordinates By Mdsys.sdo_cs.validate_wkt (Doc ID 1513540.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

The following query does work on 10.2 but fails on 11gR1 and 11gR2

select srid, cs_name, substr(wktext,1,2000) WKTEXT
  from mdsys.cs_srs
 where mdsys.sdo_cs.validate_wkt(srid)='TRUE'
 order by srid /*cs_name*/;


on 11.2 the following message is returned after 285 rows:


ORA-13249: Stmt-Execute Failure:
select CONVERSION_FACTOR from MDSYS.SDO_DIST_UNITS WHERE UNIT_NAME =
'Clarke's foot'
ORA-29400: data cartridge error
ORA-01756: quoted string not properly terminated
ORA-06512: at "MDSYS.SDO_CS", line 532
ORA-06512: at "MDSYS.SDO_CS", line 608

on 11.1 the same message is returned after 300 rows.

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