Oracle - Commit Before invoking a trigger

[chandan]

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.Modifie d 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

[Jim Kennedy]

Re: Oracle - Commit Before invoking a trigger

In an external proc AFAIK you can pass the connection that is being used and
then it would see it.
Jim
"chandan" <chandanlinux@h otmail.comwrote in message
news:8ea735ac.0 308220207.58059 d0b@posting.goo gle.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.Modifie d 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