Informix Error -9753: Unable to find User Defined Routine with the given id.
Cause and resolution
Unable to find User Defined Routine with the given id.
The user defined routine with the specified ID cannot be found.
CAUSE The user defined routine ID is incorrect or has been changed.
ACTION Correct the ID in the prepared statement and then reprepare and execute the statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9753 fires when the UDR referenced by ID in a prepared statement can't be found — per the official guidance.
- The UDR's ID being incorrect or having changed, per the official guidance — the direct, only cause.
Solutions / Resolution
- Correct the ID in the prepared statement, per the official guidance.
- Reprepare and execute the statement, per the official guidance.
Examples
N/A
No specific triggering statement is documented; the specific ID varies.
Diagnostic Checks
- Check the system catalog for the UDR's current ID, correct the prepared statement's reference, and reprepare.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -9753 in this set yet.
A prepared statement referenced a UDR ID that no longer resolves — correct the ID and reprepare.