Re: Certain dynamic sql statements make stored procedures "forget" transaction?
From: neilsolent <n_at_solenttechnology.co.uk>
Date: Wed, 15 May 2013 12:36:48 -0700 (PDT)
Message-ID: <254bf1ee-284e-47d3-8137-7ee43b2b904f_at_gw5g2000vbb.googlegroups.com>
Ah OK - I didn't notice you said there is a commit before as well as after the DDL statements.
That does make it harder to cater for all possible errors. As you say - better to do the audit record insert after the DDL in that case. Received on Wed May 15 2013 - 21:36:48 CEST
Date: Wed, 15 May 2013 12:36:48 -0700 (PDT)
Message-ID: <254bf1ee-284e-47d3-8137-7ee43b2b904f_at_gw5g2000vbb.googlegroups.com>
Ah OK - I didn't notice you said there is a commit before as well as after the DDL statements.
That does make it harder to cater for all possible errors. As you say - better to do the audit record insert after the DDL in that case. Received on Wed May 15 2013 - 21:36:48 CEST