pl/sql连接远程服务器

配置系统变量

NLS_LANG：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

TNS_ADMIN：D:PLSQL Developerinstantclient_11_2NETWORKADMIN

tnsnames.ora 文件

ORCL@IP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 数据库名)
)
)

将pl/sql中的 oci库 配置为oci.dll