Results 1 to 3 of 3

Thread: Commit problem

  1. #1
    Join Date
    Feb 2004
    Location
    inida
    Posts
    62

    Thumbs up Unanswered: 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
    Join Date
    Feb 2004
    Location
    India
    Posts
    16

    Thumbs down COMMIT PROBLEM

    Hi,
    As far as my knowledge is concerned what u r saying is not feasible.
    Because the trigger body is coupled with the firing statement,
    u can give commit for the statement after each and every trigger associated with that statement has fired.

    Aman

  3. #3
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    Re: Commit problem

    Originally posted by neema
    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 Neema,

    Your problem is not clear.
    You want to insert some records and there is trigger after insert on the table. You should read the autonomous transactions, autonomous triggers availble in oracle. Perhaps this may help you. If you can be more specific of ur requirement, then i can help you in better way.

    Thanks
    praveenpr@rediffmail.com
    (Praveen)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •