CS_Transform Fails with Oracle Internal issue
620010May 29 2011 — edited May 30 2011Hi All
While performing CS Transform-
SELECT b.UNIQUE_ID, SDO_CS.TRANSFORM(b.LOCATION_GEOM, 32611) FROM TABLENAME b
I receive the forllowing error-
---------------------------------------------------------------------------------------------------------------------------------------
ORA-13199: SRID does not exist.
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_CS", line 5018
ORA-06512: at "MDSYS.SDO_CS", line 2845
13199. 00000 - "%s"
*Cause: This is an internal error.
*Action: Contact Oracle Support Services.
Source Coordinate system is a custom create- 9982218 and when I validate using the below sql-
select SDO_CS.VALIDATE_WKT(9982218) from dual
--------------------------------------------------------------------------
"SDO_CS.VALIDATE_WKT(9982218)"
"TRUE"
Target Coordinate System is also a valid one-
select SDO_CS.VALIDATE_WKT(32611) from dual
-----------------------------------------------------------------------
"SDO_CS.VALIDATE_WKT(32611)"
"TRUE"
Is there any procedure or way to perform tranformation from custom user defined coordinate system?
Please help me out.
Thanks
Nik