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.