Error with OracleParameterCollection after 1.0 to 1.1 upgrade

  • Thread starter Thread starter Renae
  • Start date Start date
R

Renae

Probably been asked before but I cannot find a resolution:

I receive the following error when calling a stored proc in Oracle but
this works with v1.0 of the framework:

The OracleParameter with ParameterName 'p_Subscriber_ID' is already
contained by another OracleParameterCollection.

Any help would be appreciated!

Renae

Code snippet:

Dim ps As New OracleParameterCollection

ps.Add(New OracleParameter("p_Subscriber_ID",
OracleType.VarChar, 9, ParameterDirection.Input, False, 0, 0, "",
DataRowVersion.Default, PstrSubscriberId))
ps.Add(New OracleParameter("p_Subscriber_Password",
OracleType.VarChar, 15, ParameterDirection.Input, False, 0, 0, "",
DataRowVersion.Default, PstrPassword))
ps.Add(New OracleParameter("p_Result_Msg",
OracleType.VarChar, 256, ParameterDirection.Output, True, 0, 0, "",
DataRowVersion.Default, MDbNull))
ps.Add(New OracleParameter("p_Error_Msg",
OracleType.VarChar, 256, ParameterDirection.Output, True, 0, 0, "",
DataRowVersion.Default, MDbNull))
 
I dont see any problems with the way you are adding params.I dont see why
you are getting the error. Can you give more information for me to repro
this problem so that I could help you better?

Thanks,
Sushil.
 
I'm not sure what to say..

This is running on a Windows 2003 server (also an upgrade - current app
is on W2K) that was a clean install on the box.

I didn't install the Microsoft.NET Oracle client since it is already
included in the 1.1 framework. (Should I try installing the version of
the .NET Oracle client that is installed on my W2K server?)

I also am confused because it compiles successfully. I tried clearing
the collection first with no success.

Thanks, Renae
 
Back
Top