Re: Sql help

Why can't the delete trigger update the record with the user name? Update the myTable record before the delete, or update the history record after the delete.

"Gary Knopp" <gknopp_at_ascend.com> wrote in message news:8e9uu4$32q_at_nntpb.cb.lucent.com...
>
>
> 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);
>
>
>
>
>
>
>
>
>
Received on Fri Apr 28 2000 - 00:00:00 CEST