question

muralisharma-6143 avatar image
0 Votes"
muralisharma-6143 asked karenpayneoregon commented

The number of parameters does not match number of values for stored procedure

I am trying to execute a stored procedure in oracle database. I am getting ""The number of parameters does not match number of values for stored procedure" error while executing the below vb.net code. I am using Microsoft.Practices.EnterpriseLibrary.Data version 2.0"

Appreciate help. Thanks.

Dim paramValues As Object() = {daysOfInactivity, Nothing}
Dim oraCommand As OracleCommand = CType(Me.DB.GetStoredProcCommand("P_PES_CREATE_WORK_ITEM_WS.get_inactive_submitted_wos", paramValues), OracleCommand)


dotnet-csharpdotnet-visual-basic
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@muralisharma-6143 , Could you provide the related code about Method GetStoredProcCommand? It will help us to analyze your problem.

0 Votes 0 ·

Source code is from Microsoft, here.


0 Votes 0 ·

1 Answer

sadomovalex avatar image
0 Votes"
sadomovalex answered

that is wrong forum for this question

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.