After Delete Trigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: After Delete Trigger

  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Angry After Delete Trigger

    Database Version Oracle Enterprise 9.2.0.3
    O/S Solaris 2.8

    We have created an after delete trigger that is firing before the delete. The senario is as follows....

    Table A is list of userid's, when the appliaction tries to delete a row from this table we want the oracle user dropped, this is done via the trigger using a PRAGMA AUTONOMOUS_TRANSACTION.

    If the delete fails we don't want the user deleting.

    Without the trigger enabled the user does not get dropped if the delete fails but with the trigger enabled it does.

    What is even more annoying is that it works fine on the development database. I have compared the code between the 2 databases and can see nothing different.

    Originally the trigger was a BEFORE DELETE but I have dropped it and re-created it.

    Anybody got any ideas ?

    thanks

    Gary

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: After Delete Trigger

    Originally posted by Garyp
    Without the trigger enabled the user does not get dropped if the delete fails but with the trigger enabled it does.

    By any chance the rec deleted was rolled?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

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


Click Here to Expand Forum to Full Width