Informix Error -19823: Cannot use EXECUTE PROCEDURE INTO with the INSTEAD OF trigger.
Cause and resolution
Cannot use EXECUTE PROCEDURE INTO with the INSTEAD OF trigger.
You cannot use EXECUTE PROCEDURE INTO with the INSTEAD OF trigger.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-19823 fires when an INSTEAD OF trigger's action includes EXECUTE PROCEDURE INTO — per
the official guidance.
EXECUTE PROCEDURE INTOused as anINSTEAD OFtrigger's action, per the official guidance — the direct, only cause.
Solutions / Resolution
- Remove
INTOfrom theEXECUTE PROCEDUREaction, or use a different trigger action, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond EXECUTE PROCEDURE INTO used in an INSTEAD OF trigger.
Diagnostic Checks
- Check the
INSTEAD OFtrigger's action forEXECUTE PROCEDURE ... INTO.
Related Errors / Related Topics
- -19824 — "Cannot use BEFORE or AFTER action with INSTEAD OF trigger." A related
INSTEAD OF-trigger restriction, about the trigger timing rather than its action. - -19825 — "Cannot use WHEN clause if INSTEAD OF trigger is defined." A related
INSTEAD OF-trigger restriction, about theWHENclause rather than the action. - -19826 — "Cannot create INSTEAD OF trigger for a select event." A related
INSTEAD OFrestriction, about the triggering event rather than the action. - -19827 — "Cannot create an INSTEAD OF trigger on a table." A related
INSTEAD OFrestriction, about the target object rather than the action.
EXECUTE PROCEDURE INTO can't be an INSTEAD OF trigger's action — use a different action.