|
Problem IT18548
|
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: |
|
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Comment |
This APAR is a duplicate of IT27577 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.12.2016
25.09.2019
26.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
