Yes, it's no different than any other select statement. Just keep in mind that it's all one big happy transaction - if the inner stored proc aborts, so does the outer one. (Actually, that may have changed in version 8, but I don't know.)

On Nov 24, 2004, at 8:17 AM, Larry White wrote:

ne stored procedure to call another?  I would like
certain procs to call a different proc to update an audit trail
whenever they're exec


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to