Re: I can't find the right trigger
Date: Wed, 3 Jan 2001 16:49:24 +0100
Message-ID: <92vhn9$m4n$1_at_wanadoo.fr>
Your way number 2 can't work because of application architecture specificities but the number 1 work pretty good. Everything is ok now ! Thanks a lot you make me save lot of time.
Jérôme
Victor Kolesov <victor_at_prg.akhz.com> a écrit dans le message :
92ve5i$ga$1_at_news.akhz.com...
> I see two ways of solving this problem:
> 1) Keep variable which was inserted in table A by "row's insert" trigger
for
> table A
> (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.
>
>
>
>
>
Received on Wed Jan 03 2001 - 16:49:24 CET