Forum Stats

  • 3,827,312 Users
  • 2,260,760 Discussions
  • 7,897,201 Comments

Discussions

SDO_UTIL.TO_WKTGEOMETRY(GEOMETRY) Value Not Allowed Error

User_LBBN9
User_LBBN9 Member Posts: 1 Green Ribbon


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?

Tagged: