multiple instances of named argument in list

Question

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

Fuat · Answer 1 · 2019-04-08T14:07:37.003

8

May be you have added same "OracleParameter" multiple times. Please control your parameter list and remove repeated parameter(s) from your code;

edited Apr 08 '19 at 14:07

answered Jan 14 '14 at 15:15

Fuat

789
9
14

score 6 · Answer 2 · edited Nov 20 '11 at 01:03

6

use oracom.Parameters.Clear(); after executenonquery();

edited Nov 20 '11 at 01:03

animuson

53,861
28
137
147

answered Apr 19 '11 at 06:15

grishma

61
1
3

Solved my issue – Ziggler Nov 15 '17 at 19:31

score 1 · Accepted Answer · answered Apr 13 '09 at 05:47

1

Service Pack 1 for VS2008 solved the problem...

answered Apr 13 '09 at 05:47

Guy Bertental

584
2
10
24

multiple instances of named argument in list

3 Answers3