Informix Error -4063
-4063 Function "name" should not return any results.
This statement invokes the function "name" in a context that implies it should return one or more values. However, that function has been declared earlier in this module without a RETURNING clause or with RETURNING VOID. Make sure that you have called the function you intended; then review its declaration.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-4063 fires when a function is called in a context expecting a returned value, but the
function was declared without a RETURNING clause (or with RETURNING VOID) — per the
official guidance, this is a mismatch between the call's expectation and the function's own
declaration.
- A function called where a return value is expected, but it's declared
VOID(or with noRETURNINGclause), per the official guidance — the direct, only cause.
Solutions / Resolution
- Make sure the function called was the one intended, per the official guidance.
- Review the function's declaration to confirm whether it should return a value, per the official guidance.
Examples
Expecting a value from a VOID function
FUNCTION logEvent(msg CHAR(50))
-- no RETURNING clause; implicitly VOID
END FUNCTION
LET x = logEvent("started")
-- -4063: logEvent() returns nothing
Corrected
CALL logEvent("started")
Diagnostic Checks
- Check the function's
RETURNINGclause, and confirm the call site's expectations match it.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -4063 in this set yet.
A function is called where a return value is expected, but it's declared to return nothing — check the function's declaration and the call site.