I had an error when running the function ST_Transform and I could not implement it on an oracle database Has anyone had the same message in the realization of the test?
http://resources.arcgis.com/en/help/main/10.1/index.html#//006z0000009s000000. ****************************************************** ORA-20001:Unable to retrieve message ORA-06512: en SDE.ST_GEOMETRY_SHAPELIB_PKG,line 720 ORA-06512: en SDE.ST_GEOMETRY_OPERATORS,line 2594 ******************************************************
Version and Service Pack level of ArcGIS (Ej ArcInfo 10 SP3) and its Operating System. (cliente) ArcINFO 10.1 SP1 Windows 7 Profesional SP1 64 bit ArcSDE 10.1 SP1 for oracle 11g Windows Server 2008 R2 64 bit Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit for HPUX: Version 11.2.0.3.0
Can you provide the exact SQL that generates the message? It would help if you could provide the coordinate reference information for the SRIDs involved.
Is the ST_GEOMETRY library installed correctly in the listener?
Transforming data when the source and destination spatial references do not have the same geographic coordinate system (Oracle only) The following CREATE TABLE statement creates the n27 table, which contains an ID column and an ST_Geometry column:
CREATE TABLE n27 (id integer, geometry sde.st_geometry); INSERT INTO N27 (id, geometry) VALUES ( 1, sde.st_geometry ('point (-123.0 49.0)', 4267)); CREATE TABLE n83 (id integer, geometry sde.st_geometry); INSERT INTO N83 (id, geometry) VALUES ( 1, sde.st_transform ( (select geometry from N27 where id=1), 4269, 1241));
The ST_TRANSFORM documentation references the PEDATAHOME variable. The ST_GEOMETRY documentation states:
If you plan to use the ST_Transform function to perform geographic transformations, you must copy the pedata folder from your ArcGIS for Desktop installation directory, place it on the Oracle server, and set a PEDATAHOME environment variable on the server that points to that location
