Hi.

You can do that with Oracle's internal auditing:

http://www.oracle-base.com/articles/8i/Auditing.php

You can have an audit trail in the DB, or on the filesystem. It will be alot quicker than manually coding it for yourself. In 10g Release 2, you can product XML output for the audit trail.

Cheers

Tim...