| | | | Browse by category |
Article ID: 793
Last updated: 05 Feb, 2008
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.
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
Powered by KBPublisher (Knowledge base software)