Sql Help

Hello,

    I have an application that connects to an oracle database through a single
user account. When the application issues an 'update' or 'insert' it sends the username as part of the sql syntax...

                 Update myTable
                        set f1 = 'blah'
                              f2 = 'blahblah'
                              user = 'Smith'

Triggers are used to store the old record value and username in a history table.

The problem is if I have a 'delete' statement there is no way to send the username along with the sql syntax to identify who is deleting the record. The delete trigger can write the record to the history table, but with no user identified. Although I could issue a separate sql statement to insert the old record into the history table for Deletes. I would rather the database
trigger handle that.

Is there anyway I can create a procedure to set a variable that the delete trigger can use to fill in the username???

                        procedure delRecord(sql,username);