Hi,
Instead of writing a trigger U can enable auditing which gives u more wide information.
The audit records are stored in AUD$ in sys schema and u can see the table to get the information.

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]