topic Re: Error ST_TRANSFORM (oracle) in Data Management Questions

Error ST_TRANSFORM (oracle)

FranciscoAcosta_Bazán — Thu, 18 Jul 2013 14:51:44 GMT

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

Re: Error ST_TRANSFORM (oracle)

VinceAngelo — Thu, 18 Jul 2013 15:12:20 GMT

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?

- V

Re: Error ST_TRANSFORM (oracle)

FranciscoAcosta_Bazán — Thu, 18 Jul 2013 15:37:27 GMT

ST_GEOMETRY library if it works well
ST_TRANSFORM
I'm just following the test :
http://resources.arcgis.com/en/help/main/10.1/index.html#//006z0000009s000000

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));

Re: Error ST_TRANSFORM (oracle)

VinceAngelo — Fri, 19 Jul 2013 09:57:15 GMT

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

Tech Support can help you do this correctly.

- V