Hi, I am trying to execute a stored procedure using the dataprovider, but when i execute it, i always get following error: "Parameter count does not match parameter value count". The count of my SP parameters is the same as those in the code bellow. Any idea what can be wrong? Thanks in advance.

Dim objParameters As New ParameterCollection

objParameters.Add("PI_CLIENTNUMBER", OracleClient.OracleType.VarChar, ParameterDirection.Input, 20)

objParameters.Add("PI_LABNUMBER", OracleClient.OracleType.VarChar, ParameterDirection.Input, 20)

objParameters.Add("PI_INVOICENUMBER", OracleClient.OracleType.VarChar, ParameterDirection.Input, 20)

objParameters.Add("PO_RETURNVALUE")

objParameters("PI_CLIENTNUMBER") = objUser.ClientNumber

objParameters("PI_LABNUMBER") = objUser.LabNumber

objParameters("PI_INVOICENUMBER") = objUser.InvoiceNumber

Dim dr As IDataReader = DataProvider.Instance().ExecuteReader("IsValidUser", objParameters)

If dr.Read Then

Return True

Else ' does not exist

Return False

End If

dr.Close()

Can you by any chance send me your stored procedure itself - I'm thinking your error might be in the stored procedure...

Tim - trying doing this and see whether your problem goes away 

a) change the PO_RETURNALUE data type to a cursor (look at any of the default sprocs in DNN to see an example - typically the get_XXX would have the output parameter).
b) modify your return statements to use the cursor - similar to open PO_RETURNVALUE for select 1 from DUAL;
c) You shouldn't have to change anything on your code side since you're already trying to read the datareader...


Try this and let me know if this works..
Thanks

Sanjay