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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top