我要连接一台远程的数据库服务器,在pl/sql中是这样:192.168.1.100:1521:myora,在proc中连接时怎么写
有人说是这样exec sql connect :user identified :pwd using :dbhost。但是这里的dbhost要怎么写,我写192.168.1.100或192.168.1.100:1521:myora都不行
有人说是这样exec sql connect :user identified :pwd using :dbhost。但是这里的dbhost要怎么写,我写192.168.1.100或192.168.1.100:1521:myora都不行
这条语句,我试过:
dbhost= 192.168.1.100:1521:myora时错误ORA-06401: NETCMN: invalid driver designator
dbhost = 192.168.1.100时错误ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connec
dbhost = 192.168.1.100:myora时错误ORA-06401: NETCMN: invalid driver designator