Oracle 数据库连接字符串 PLSQL 兼容性
我正在使用一个名为 Logi info 的应用程序。它需要一个到我的 oracle 数据库的连接字符串。连接工作正常，但为了配置连接以从数据库接收引用游标， 我显然需要将 PLSQLRSet=1 添加到字符串末尾。当我这样做时，我收到错误“无效的连接字符串”
这是我的连接字符串，没有 plsqlrset=1
Data Source=SID; User Id=username; Password=password;
我担心的是 PLSQLRSet=1 可能只是 .NET 参数。任何人都可以阐明这个问题吗？
谢谢
I'm using an application called Logi info. it requires a connection string to my oracle database. the connection works fine but in order to configure the connection to recive ref cursors from the database, I apparently need to add PLSQLRSet=1 to the end of the string. when I do that I recieve an error "invalid connection string"
Here is my connection string without plsqlrset=1
Data Source=SID; User Id=username; Password=password;
My concern is that PLSQLRSet=1 might be .NET paramater only. Can anyone shed some light on the issue.
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看来
PLSQLRset选项是 OraOLEDB 提供程序的一项功能（根据 http://download.oracle.com/docs/cd/B10501_01/win.920/a95498/using.htm）。因此，我猜测您必须将 Provider=OraOLEDB.Oracle 添加到连接字符串（如您链接到的页面上的屏幕截图所示）才能使用此选项。
It appears that the
PLSQLRsetoption is a feature of the OraOLEDB provider (per http://download.oracle.com/docs/cd/B10501_01/win.920/a95498/using.htm).Therefore I would guess that you have to add
Provider=OraOLEDB.Oracleto the connect string -- as shown in the screenshot on the page you linked to -- in order to use this option.