Oracle - Commit Before invoking a trigger

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 - 12:07:13 CEST