Re: I can't find the right trigger

I see two ways of solving this problem:
[Quoted] 1) Keep variable which was inserted in table A by "row's insert" trigger for table A

[Quoted]      (seq_A.nextval ) in Package variable     and use POST-INSERT trigger to return package variable from server (I use function from this package. see attachment)

2) in row's after insert trigger for table A

    do
     insert into table B (using variable selected from seq_A.nextval)

--
Best regards.
Victor Kolesov.




begin 666 SAVE_SL_VAR.PKS
M0U)%051%($]2(%)%4$Q!0T4_at_4$%#2T%'12!3879E7U-L7U9A<B!!4PT*("!&
M54Y#5$E/3B!G971?:61?;G5M(%)%5%523B!)3E1%1T52.PT*("!04D%'34$_at_
M4D535%))0U1?4D5&15)%3D-%4RAG971?:61?;G5M+'=N9',I.PT*("!S;%]N
M86QO9VE?:60_at_4TQ?3D%,3T=)+FED7VYU;25465!%(#H](# [#0I%3D0_at_4V%V
M95]3;%]687([#0HO#0H-"D-214%412!/4B!215!,04-%(%!!0TM!1T4_at_0D]$
M62!3879E7U-L7U9A<B!!4PT*("!&54Y#5$E/3B!G971?:61?;G5M(%)%5%52
M3B!)3E1%1T52($%3#0H_at_($)%1TE.#0H@(" @(%)%5%523B!S;%]N86QO9VE?
D:60[#0H_at_($5.1#L-"D5.1"!3879E7U-L7U9A<CL-"B\-"@T*


`

end

begin 666 AI_SL_NA.sql
M0U)%051%($]2(%)%4$Q!0T4_at_5%))1T=%4B B1DE.(BY!25]33%].04Q/1TD-
M"B!!1E1%4B!)3E-%4E0_at_3TX@<VQ?;F%L;V=I#0I&3U(@14%#2"!23U<-"D)%
M1TE.#0H_at_('-A=F5?<VQ?=F%R+G-L7VYA;&]G:5]I9" Z/2 Z;F5W+FED7VYU
*;3L-"D5N9#L-"_at_``


`

end

begin 666 bI_SL_NA.sql
M0U)%051%($]2(%)%4$Q!0T4_at_5%))1T=%4B B1DE.(BY/3E])3E-?4TQ?3D%,
M#0H_at_0D5&3U)%($E.4T525"!/3B!S;%]N86QO9VD-"D9/4B!%04-((%)/5PT*
M0D5'24X-"FEF(#I.15<N:61?;G5M(&ES(&YU;&P_at_=&AE;@T*(" @('-E;&5C
M="!I9%]P;&%T7VYA;"Y.15A45D%,(&EN=&\_at_.DY%5RYI9%]N=6T_at_9G)O;2!D
5=6%L.PT*96YD(&EF.PT*16YD.PT*


`

end