Re: Bug/Crash - IDS11 - Data Collection + SPL with REFERENCING

jprenaut@yahoo.com wrote: > On Feb 11, 6:22 pm, "Art S. Kagel (Oninit LLC)" <a...@oninit.com> > wrote: > >> Cesar Inacio Martins wrote: >> >>> Hi, >>> >>> IDS 11.10 UC1DE , OS SuSE 10.2 >>> >>> I try create a Stored Procedure with trigger references, when I >>> execute the script the instance create a Assert Failed and crash. >>> After a some tests I discovered the problem is when have a >>> collection variable declared on procedure with trigger references. >>> When execute the SQL bellow, the same error occur. >>> >>> The problem apparently is on the memory allocation... >>> I want to know if anybody have a idea to do a work around without >>> pass parameter on the SPL. >>> >>> -------------------------- SQL >>> >>> CREATE table t_tag_perg ( >>> cod_pergunta integer >>> ,cod_tag integer >>> )>>> ; >>> CREATE procedure sp_trg_tag_perg()>>> referencing old as o new as n for t_tag_perg; >>> ----------------->>>> when comment the line bellow OR above, the SP >>> is created >>> define v_tags set(integer not null); >>> end procedure >>> ; >>> -- this code is not are executed... the error occur on the create >>> procedure. >>> CREATE trigger trg_i_tag_perg insert on t_tag_perg >>> for each row ( >>> execute procedure sp_trg_tag_perg() with trigger references >>> )>>> ; >>> -- this code is not are executed... the error occur on the create >>> procedure. >>> CREATE trigger trg_i_tag_perg delete on t_tag_perg >>> for each row ( >>> execute procedure sp_trg_tag_perg() with trigger references >>> )>>> ; >>> >> I'm surprised that it caused an AF event, but you can't do what you want >> to do. You create the procedure with the expected argument list and >> pass values from the trigger's old and new images to the procedure. >> There's no other way in Informix's syntax. The stored procedure knows >> nothing about old or new. >> >> Art S. Kagel >> Oninit >> >> =========================================================================================== >> Please access the attached hyperlink for an important electronic communications disclaimer: >> >> http://www.oninit.com/home/disclaimer.php >> >> =========================================================================================== >> > > This is a new feature of 11. You can create trigger procudures > (you'll note the create trigger execute procudure with references > syntax that allows the procedure to use the old and new stuff). I was > able to duplicate the crash using 11.10.UC1 on Solaris so it isn't > specific to Linux. Didn't get a lot of time to play around seeing if > there's a workaround, but it certainly does appear to be a bug. > > Jacques D'uh! I did double check to see if I was missing something, but forgot that I keep my links set to the 10.00 manuals 'cause we have no clients on 11.10 in production yet. Mon faux. Keep me honest, Jacques. Art S. Kagel Oninit =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================