|
Problem IT18548
|
Status: Geschlossen |
TRIGGER CALLING A STORED PROCEDURE USING SET PARAMETER CAUSES EXCEPTION IN INSONE_NEXT EXPRESSION EVALUATION
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problembeschreibung: |
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-Zusammenfassung: |
|
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Kommentar |
This APAR is a duplicate of IT27577 |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.12.2016
25.09.2019
26.10.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
