NIM058409 for ArcSDE/Enterprise Geodatabase

Numéro d’ID de bogue	NIM058409
Envoi	June 18, 2010
Dernière modification	April 28, 2025
S’applique à	ArcSDE/Enterprise Geodatabase
Version trouvée	9.3.1
Système d’exploitation	Windows OS
Version du système d’exploitation	2008 64 Bit
Statut	Non-Reproducible

Informations supplémentaires

Non-reproducible with 10.1.

Solution de contournement

Include the EXTPROC_CONNECTION_DATA Service Name in Tnsnames.ora file and add SDEHOME/bin path to the Listener for configuring ST_GEOEMTRY -SQL functions.- Copy of Listener.ora and Tnsnames.ora files:LISTENER.ORA------------SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = <a href="file:C:/Oracle11GR2/product/11.2.0/dbhome_1)" target="_blank">C:\Oracle11GR2\product\11.2.0\dbhome_1)</a> (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=<a href="file:C:/Oracle11GR2/product/11.2.0/dbhome_1/bin/oraclr11.dll,PATH=C" target="_blank">C:\Oracle11GR2\product\11.2.0\dbhome_1\bin\oraclr11.dll,PATH=C</a>:\Oracle11GR2\product\11.2.0\dbhome_1\bin") ) (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = <a href="file:C:/Oracle11GR2/product/11.2.0/dbhome_1)" target="_blank">C:\Oracle11GR2\product\11.2.0\dbhome_1)</a> (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=<a href="file:C:/ESRI931/ArcSDE/ora11gexe/bin/st_shapelib.dll,PATH=C" target="_blank">C:\ESRI931\ArcSDE\ora11gexe\bin\st_shapelib.dll,PATH=C</a>:\ESRI931\ArcSDE\ora11gexe\bin") ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) (ADDRESS = (PROTOCOL = TCP)(HOST = <a href="http://pepper.esri.com" target="_blank">pepper.esri.com</a>)(PORT = 1521)) ) )ADR_BASE_LISTENER = <a href="file:C:/Oracle11GR2" target="_blank">C:\Oracle11GR2</a>TNSNAMES.ORA------------EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )ORA11GR2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <a href="http://pepper.esri.com" target="_blank">pepper.esri.com</a>)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORA11GR2) ) )SQL> select objectid, name, sde.st_astext(a.shape) from gdb.canada a where name like 'N%' order by 1; OBJECTID NAME SDE.ST_ASTEXT(A.SHAPE)---------- ------------------------- -------------------------------------------------------------------------------- 2 Northwest Territories MULTIPOLYGON ((( -92.74379730 69.67195129, -92.53500366 69.70942688, -92.867767 3 Nova Scotia MULTIPOLYGON ((( -64.04279327 45.99190140, -64.15499878 45.96887970, -64.272926 6 Newfoundland and Labrador MULTIPOLYGON ((( -64.53482056 60.30260086, -64.85388184 60.26166916, -64.851936 8 New Brunswick MULTIPOLYGON ((( -69.03971100 47.29714966, -69.03723144 47.25733185, -68.895393