Re: Oracle - Commit Before invoking a trigger

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Fri, 22 Aug 2003 15:02:32 GMT
Message-ID: <cgq1b.172918$It4.84226_at_rwcrnsc51.ops.asp.att.net>


In an external proc AFAIK you can pass the connection that is being used and then it would see it.
Jim
"chandan" <chandanlinux_at_hotmail.com> wrote in message news:8ea735ac.0308220207.58059d0b_at_posting.google.com...
> hi,
> I have a insert trigger on a table. I want commit to happen after
> insert before invoking the trigger. So that if a quey is made before
> the completion of the trigger.Modified Data should be visible.
>
> Let me explain the why i want this.
> The triger calls a java stored procedure which invokes an external
> ejbclient which calls the ejb. The ejb queries the database for the
> modified changes but it is getting old data since commit happens after
> completion of the trigger where i want the new data. So i want the
> commit to happen before trigger invocation.Is there any setting in
> oracle 8i to perform this.
> regards
> Chandan.B
Received on Fri Aug 22 2003 - 17:02:32 CEST

Original text of this message