multiple instances of named argument

  • Thread starter Thread starter rbutch
  • Start date Start date
R

rbutch

has anyone ever experienced this when calling a stored procedure from oracle?
when i open up the form and type in my variable to be used in the stored procedure, IT WORKS JUST FINE ONCE.
but, to, say, change the variable and look for something else causes this and the only recourse is to close the program - re-open it and make another call.
since the arguments come from the client side, i hardly think its an oracle problem and in the stored procedure, i do close the cursor.

is there a step im missing?
thanks
this forum is great
rik

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
 
this is the error i receive("multiple instances of named argument in list") - should have posted this the first time.
thanks
rik

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
 
well, i figured it out.
just clear out the parameters. evidently it hangs on to them.
thanks
rik

daOrgSecurity.SelectCommand.Parameters.Clear()

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
 
Back
Top