Skip to Main Content

LiveLabs & Workshops

SDO_UTIL.TO_WKTGEOMETRY(GEOMETRY) Value Not Allowed Error

User_LBBN9Apr 27 2022

i have an object table and SRID 2000273
i execute the following query to get the wkt string of the geometry in the table

SELECT SDO_UTIL.TO_WKTGEOMETRY(GEOMETRY) FROM myTABLE

i get following errors;

ORA-24323: value not allowed  
ORA-06512: location "MDSYS.MDPRVT_SRID",line 143  
ORA-06512: location "MDSYS.SDO_UTIL", line 320

i insert mdsys.cs_srs table about my table's srid record
insert into MDSYS.cs_srs values ('TM 27 3 DERECE',2000273,2000273,'Oracle','PROJCS["TM 27 3 DERECE",GEOGCS["OpenGIS.European_Datum_1950",DATUM["OpenGIS.European_Datum_1950",SPHEROID["International 1924",6378388.000000,297.000000]],PRIMEM["Greenwich",0.000000],UNIT["Decimal Degree",0.01745329251994330]],PROJECTION["Transverse Mercator"],PARAMETER["Scale_Factor",1.000000],PARAMETER["Central_Meridian",27.000000],PARAMETER["False_Easting",500000.000000],PARAMETER["False_Northing",0],PARAMETER["Latitude_of_Origin",0],UNIT["Meter",1.000000000000]]',NULL);
What is the reason for this error? Where else should I check?

Comments
Post Details
Added on Apr 27 2022
0 comments
37 views