Skip to Main Content

Database Software

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!

CS_Transform Fails with Oracle Internal issue

620010May 29 2011 — edited May 30 2011
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2011
Added on May 29 2011
1 comment
860 views