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

[Jim Kennedy]

In an external proc AFAIK you can pass the connection that is being used and
then it would see it.
Jim
"chandan" <ch**********@hotmail.com> wrote in message
news:8e**************************@posting.google.c om...

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