routine <str> expects between <num> and <num> parameter(s) Explanation: You may truncate the procedure or function parameter list when those parameters are IN parameters. They will then use the defined DEFAULT or be passed as NULL. In this case you passed too few parameters. User Action: Specify the correct number of parameters upon invocation.