Informix Error -79887: Parameter name not found.
Cause and resolution
Parameter name not found.
A parameter name is not found in the argument names of the specified stored procedure. Either one of the parameter names is not valid or the stored procedure name is incorrect.
Correct the parameter or procedure name and run the procedure again.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-79887 fires when a named parameter isn't found among a stored procedure's argument names — per the official guidance.
- An invalid parameter name, per the official guidance — the first named case.
- An incorrect stored procedure name, per the official guidance — the second named case.
Solutions / Resolution
- Correct the parameter name or the procedure name, and run the procedure again, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an unmatched parameter name.
Diagnostic Checks
- Check the parameter name against the stored procedure's actual argument names, and the procedure name itself, correcting either as needed.
Related Errors / Related Topics
- -79888 — "Parameters are specified by both name and ordinal position for the same
CallableStatement object." A related
CallableStatementparameter error, on mixing name/ordinal references rather than an unmatched name.
A named parameter wasn't found among the stored procedure's arguments — correct the parameter or procedure name.