Thread: Commit problem

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    11
    Rep Power
    0

    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.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    3
    Rep Power
    0

    Post Re: Commit Problem


    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.



    Originally Posted by raseena
    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.

IMN logo majestic logo threadwatch logo seochat tools logo