Re: buggy posting :-)

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 24 Mar 2001 17:38:34 -0800
Message-ID: <3ABD4C1A.E8F8AA0B@exesolutions.com>

And yes for any DDL such as ALTER TABLE you must use dynamic SQL. I assumed that was already in the code and didn't elaborate.

Daniel A. Morgan

Frank wrote:

> Hi!
>
> I missed in the copy/paste :-)
> This test is a little bit more convincing.
>
> Frank
>
> BEGIN
> ALTER TABLE test ADD col3 NUMBER;
>
> EXCEPTION
> WHEN OTHERS THEN
> ALTER TABLE test ADD col3 NUMBER;
>
> END;
> /
Received on Sat Mar 24 2001 - 19:38:34 CST