ST_Geometry 的相关问题

文章分类:Java编程

1.为使用ST_Geometry SQL函数配置oracle的网络服务

修改 oraclehome/NETWORK/ADMIN目录下listener.ora文件

打开listener.ora文件，添加如下一句

Java代码

1. (ENVS="EXTPROC_DLLS=C:/Program Files/ArcGIS/ArcSDE/ora10gexe/bin/st_shapelib.dll")  

(ENVS="EXTPROC_DLLS=C:/Program Files/ArcGIS/ArcSDE/ora10gexe/bin/st_shapelib.dll")

这里根据具体情况修改st_shapelib.dll的实际路径。

修改以后的listener.ora文件如下

 

1. # listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1   
2. /network/admin/listener.ora   
3. # Generated by Oracle configuration tools.   
4. SID_LIST_LISTENER =   
5.   (SID_LIST =   
6.     (SID_DESC =   
7.       (SID_NAME = PLSExtProc)   
8.       (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)   
9.       (PROGRAM = extproc)   
10. (ENVS="EXTPROC_DLLS=C:/Program Files/ArcGIS/ArcSDE/ora10gexe/bin/st_shapelib.dll")   
11.     )   
12.   )   
13. LISTENER =   
14.   (DESCRIPTION_LIST =   
15.     (DESCRIPTION =   
16.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))   
17.       (ADDRESS = (PROTOCOL = TCP)(HOST = zbc)(PORT = 1521))   
18.     )   
19.   )  

# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1
/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=C:/Program Files/ArcGIS/ArcSDE/ora10gexe/bin/st_shapelib.dll")
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = zbc)(PORT = 1521))
    )
  )

listener.ora文件如下

Java代码

1. # listener.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/network/admin/listener.ora   
2. # Generated by Oracle configuration tools.   
3.   
4. SID_LIST_LISTENER =   
5.   (SID_LIST =   
6.     (SID_DESC =   
7.       (SID_NAME = PLSExtProc)   
8.       (ORACLE_HOME = C:/oracle/product/10.2.0/db_1)   
9.       (PROGRAM = extproc)   
10.       (ENVS="EXTPROC_DLLS=C:/Program Files/ArcGIS/ArcSDE/ora10gexe/bin/st_shapelib.dll")   
11.     )   
12.   )   
13.   
14. LISTENER =   
15.   (DESCRIPTION_LIST =   
16.     (DESCRIPTION =   
17.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))   
18.       (ADDRESS = (PROTOCOL = TCP)(HOST = esriwinxp)(PORT = 1521))   
19.     )   
20.   )  

# listener.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
      (ENVS="EXTPROC_DLLS=C:/Program Files/ArcGIS/ArcSDE/ora10gexe/bin/st_shapelib.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = esriwinxp)(PORT = 1521))
    )
  )

tnsnames.ora文件如下

Java代码

1. # tnsnames.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora   
2. # Generated by Oracle configuration tools.   
3.   
4. ORCL =   
5.   (DESCRIPTION =   
6.     (ADDRESS = (PROTOCOL = TCP)(HOST = esriwinxp)(PORT = 1521))   
7.     (CONNECT_DATA =   
8.       (SERVER = DEDICATED)   
9.       (SERVICE_NAME = orcl)   
10.     )   
11.   )   
12.   
13. EXTPROC_CONNECTION_DATA =   
14.   (DESCRIPTION =   
15.     (ADDRESS_LIST =   
16.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))   
17.     )   
18.     (CONNECT_DATA =   
19.       (SID = PLSExtProc)   
20.       (PRESENTATION = RO)   
21.     )   
22.   )  

# tnsnames.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = esriwinxp)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

如下错误：

用plsql查看


查看st_shapelib属性


加载dll是否正确