Informix Error -26061: Procedure (%s) was created with an older version of the server and must be dropped and recreated again in order to work properly.

Reasons / Common Causes

-26061 fires when the named SPL procedure was created under an older server version and contains constructs the current server can no longer run as originally compiled — per the official guidance.

1. The procedure contains CREATE TRIGGER, CREATE TABLE with fragmentation expressions, ALTER TABLE/CREATE TABLE with constraint expressions, or nested CREATE PROCEDURE statements, per the official guidance — the direct, only cause; such procedures need recompiling under the current server.

Solutions / Resolution

1. Drop and recreate the named procedure using the current server, per the official guidance.

Examples

Recreating an old procedure

DROP PROCEDURE old_proc;
CREATE PROCEDURE old_proc()
  ...
END PROCEDURE;

Diagnostic Checks

1. Check the named procedure's body for CREATE TRIGGER, fragmentation/constraint expressions, or nested CREATE PROCEDURE, and drop/recreate it under the current server.

Related Errors / Related Topics

• -26060 — "Procedure was created with an older version of the engine and must be dropped and created again in order to work properly." The same condition, worded for "engine" rather than naming the specific procedure and using "server."

A named procedure created under an older server version needs to be dropped and recreated under the current server.