Hi,
I am trying to add SRID 5221 to Oracle 11gR2.
As such I tried:
insert into mdsys.cs_srs (cs_name, srid, wktext) values ('S-JTSK (Ferro) / Krovak East North', 5221,
'PROJCS["S-JTSK (Ferro) / Krovak East North", GEOGCS["S-JTSK (Ferro)", DATUM["System_Jednotne_Trigonometricke_Site_Katastralni_Ferro", SPHEROID["Bessel 1841", 6377397.155, 299.1528128], TOWGS84[589,76,480,0,0,0,0]], PRIMEM["Ferro",-17.66666666666667], UNIT["Decimal Degree", 0.0174532925199433]], PROJECTION["Krovak Oblique Conic Conformal"], PARAMETER["latitude_of_center", 49.5], PARAMETER["longitude_of_center", 42.5], PARAMETER ["azimuth", 30.28813972222222], PARAMETER ["pseudo_standard_parallel_1", 78.5], PARAMETER ["scale_factor", 0.9999], PARAMETER ["false_easting", 0], PARAMETER ["false_northing", 0], UNIT ["metre",1], AXIS["X",EAST], AXIS["Y",NORTH]]');
But it keeps failing the wkt test.
select sdo_cs.validate_wkt(5221) from dual;
And when trying to create a spatial index based on the above crs, it fails with.
SQL Error: ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-13282: failure on initialization of coordinate transformation
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 313
29858. 00000 - "error occurred in the execution of ODCIINDEXALTER routine"
*Cause: Failed to successfully execute the ODCIIndexAlter routine.
*Action: Check to see if the routine has been coded correctly.
Thank you,
Patrick