列表中命名参数的多个实例
我在从 Visual Studio 2008 的服务器资源管理器执行 Oracle 过程时遇到问题,
当我尝试执行过程时,所有输入参数都会加倍!
它只发生在我的一台工作站上,我尝试重新安装oracle产品, 但这对我没有帮助...
当我尝试执行该过程时,我收到以下错误消息:
ORA-06550: line 1, column 7:
PLS-00703: multiple instances of named argument in list
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
我的数据连接类型是“Oracle Database”,提供程序是“.NET Framework Data Provider for Oracle”。
此致, 盖伊·贝尔坦塔尔
I have a problem executing oracle procedures from Visual Studio 2008's Server Explorer,
when i try to execute a procedure all the input parameters are doubled!
it only happend to me in one workstation, i've tried to reinstall oracle products,
but it doesn't helped me...
i get the following error message when i try execute the procedure:
ORA-06550: line 1, column 7:
PLS-00703: multiple instances of named argument in list
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
My Data Connection type is "Oracle Database" and the provider is ".NET Framework Data Provider for Oracle".
Best Regards,
Guy Bertental
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
???? May be you have added same "OracleParameter" multiple times.
Please control your parameter list and remove repeated parameter(s) from your code;
使用oracom.Parameters.Clear();
在
executenonquery();
之后use
oracom.Parameters.Clear();
after
executenonquery();
VS2008 的 Service Pack 1 解决了这个问题...
Service Pack 1 for VS2008 solved the problem...