Forum Discussion

Cogenics's avatar
Cogenics
New Contributor
5 years ago

The number of parameter values set or registered does not match the number of parameters., Reason: Script failed with the following error: The number of parameter values set or registered does not match the number of parameters

When I try to call a SP in DB2 using script snap with python language which has total 7 parameters out of it 5 are input and 2 are output parameters. I am getting below error even though I am registe...
Cogenics's avatar
Cogenics
New Contributor
5 years ago

I have the hook object at the end of script. it may not visible in my post.

  • mbowen's avatar
    mbowen
    Employee
    5 years ago

    Are you missing double quotes in your prepareCall? That is, "CALL SP('" and trailing single quote should be closed "'".