After Delete Trigger

[Garyp]

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

[abhaysk]

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?