Informix - Problem description
Problem IT27577 | Status: Closed |
TRIGGER CALLING A STORED PROCEDURE USING SET PARAMETER CAUSES EXCEPTION IN INSONE_NEXT EXPRESSION EVALUATION | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
In a complex environment an insert trigger is defined on a table in order to track changes on the base table for change logging reasons in another history table. If the base table had a SET column and the trigger processing the insert is calling another SP which handleS the SET in the parameter list, a subsequent call of the insert operation causes an assertion failure with the following stack: (oninit)afstack (oninit)afhandler (oninit)affail_interface (oninit)mt_ex_throw_sig@AF11_4 (oninit)afsig_handler (oninit)new_eval (oninit)new_eval (oninit)insone_next (oninit)doinsert (oninit)aud_doinsert (oninit)excommand (oninit)IPRA.$ip_evalsql (oninit)runproc (oninit)udrlm_spl_execute (oninit)udrlm_exec_routine (oninit)udr_execute (oninit)exroutine (oninit)execproc (oninit)aud_execproc (oninit)excommand (oninit)dotrigs (oninit)ferafttrig (oninit)dodmlrow (oninit)dodelupd (oninit)aud_dodelupd (oninit)excommand (oninit)IPRA.$ip_evalsql (oninit)runproc (oninit)udrlm_spl_execute (oninit)udrlm_exec_routine (oninit)udr_execute (oninit)exroutine (oninit)execproc (oninit)aud_execproc (oninit)excommand (oninit)sq_execute (oninit)sqmain | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS versions prior to 11.70.xC10. * **************************************************************** * PROBLEM DESCRIPTION: * * TRIGGER CALLING A STORED PROCEDURE USING SET PARAMETER * * CAUSES EXCEPTION IN INSONE_NEXT EXPRESSION EVALUATION * **************************************************************** * RECOMMENDATION: * * Fixed in IDS 11.70.xC10 if and when it becomes available. * * If this fix is required, contact Informix Technical Support. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.12.2018 26.10.2019 26.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC10 | |
Problem solved according to the fixlist(s) of the following version(s) |