Skip to Main Content

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
160 views