i have stored procedure as follows
proc_multi_trans()
{
insert stmt
// here i want to make a log in a file tht insert is success
update stmt
// here i want to make a log in a file tht update cmd is success
delete stmt
// here i want to make a log in a file tht delete cmd is success
}
i want to make those log entries..can anyone tell me whts the best way to achieve this?. plzz help