At 11:54 PM 10/10/2005 +0000, Adam wrote:

>Seriously though, one thing that concerns me about this solution is
>the mixture of DDL and DML in the single transaction. It is no secret
>that at times, this causes weird behaviour. Whether it is safe or not
>for generators I do not know.

It's not. Your concerns are perfectly justified. Programmers who are
determined to shoot themselves in the foot will find an amazing variety of
ways to do so with EXECUTE STATEMENT - the current example being just one
case in point. Extrapolate the conditions so that, after running this
procedure, you roll back the transaction, and you'll get my drift.

>While it is not my job to tell others how they should code, it is the
>right thing to do to warn about known gotchas.

Real programmers don't jump out of aeroplanes without parachutes.

./heLen