Is it possible for one stored procedure to call another? I would like certain procs to call a different proc to update an audit trail whenever they're executed.
I thought about using triggers but want the trail to include info that's not in the updated table - specifically the application user ID of the responsible party. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend