Commit problem

hi,

Im facing a problem.

I've a trigger which is getting fired while afteer insertion (statement)of a table.But that parent statement is not getting commited. I do wanna parent insert into be commited before firing the trigger or before trying to do some actions inside my trigger..



any kind of suggestions??thanx.

Hi raseena,
I'm not able to get ur problem, are u trying to say that u don't have any problem in trigger, but in normal Query?? Can't u execute commit explicitly after each Query. I faced similar problem while doing some prog. in Java, there we use to explicitly commit each Query except select.
Try that one, after that let the trigger be fired!!!

Hope it would solve the problem...

luv,
floweringcactus.