Error when executing a stored procedure.

Article ID: 793
Last updated: 05 Feb, 2008
Article ID: 793
Last updated: 05 Feb, 2008
Revision: 1
Views: 9250
Posted: 26 Jun, 1997
by Dean J.
Updated: 05 Feb, 2008
by Dean J.
Problem


While executing a stored procedure, I get the error:
Invalid position error in stored procedure.


Cause


This error is usually generated when the number of arguments passed to a stored procedure is different from the number of parameters defined. DBTools.h++ checks only if too many arguments are passed, and does not check for too few arguments, since the database may supply the defaults. This applies to both the number of input and the number of output parameters.


Action


Verify that the number of arguments passed to the stored procedure is exactly equal to (or less than) the number of parameters expected. Input parameters are passed by value and output parameters are passed by reference. For procedures taking a large number of parameters, it is recommend to use the public member operator RWDBStoredProc& operator[](const RWCString& paramName). Be aware of procedure existence.
This article was:   Helpful | Not helpful
Report an issue
Article ID: 793
Last updated: 05 Feb, 2008
Revision: 1
Views: 9250
Posted: 26 Jun, 1997 by Dean J.
Updated: 05 Feb, 2008 by Dean J.

Others in this category