Oninit
Talk to an expert →

Informix Error -79827: Function does not have an output parameter.

Cause and resolution

Function does not have an output parameter.

This function does not have an OUT parameter, or this function has an OUT parameter whose value the server version does not return. None of the methods in the CallableStatement interface apply.

Use the inherited methods from the PreparedStatement interface.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-79827 fires when CallableStatement methods are used on a function with no usable OUT parameter — per the official guidance.

  1. A function with no OUT parameter at all, per the official guidance — the first named case.
  2. A function with an OUT parameter whose value the server version doesn't return, per the official guidance — the second named case.
Solutions / Resolution
  1. Use the inherited PreparedStatement methods instead, per the official guidance — no CallableStatement method applies here.
Examples
N/A

No specific triggering statement is documented beyond a function with no usable OUT parameter.

Diagnostic Checks
  1. Check whether the function has an OUT parameter the server version actually returns, and use PreparedStatement methods if not.
Related Errors / Related Topics
  • -79828 — "Function parameter specified is not an OUT parameter." A related OUT-parameter error, on naming the wrong parameter index rather than the function having none at all.

The function has no usable OUT parameter — use the inherited PreparedStatement methods instead of CallableStatement.