I got it working, It's something I miss in the code. Still I am having problem implementing this, I talked to our Developers and they told me that they cannot give me the SID from oracle and the USER ID from their application because they are saying that they are using 'container management bean'.

How are you implementing Auditing at the database level when users are comming in from a webserver pool? (Using the same user_id).

What I mean by auditing is capturing the user id who perform a delete or update within the database. In a client server environment this will be easy.

Can you give me some advice on how to do just this in a three tier environement.