Re: Supporting multiple oracle versions in a trigger

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 20 Oct 2005 00:47:20 +0200
Message-ID: <e6jdl153ukq1hjtehv2uo4e665lf9r1d7l@4ax.com>

On Wed, 19 Oct 2005 18:54:57 GMT, "Jack Addington" <jaddington_at_shaw.ca> wrote:

>I have a storedproc that drops/creates tables using dynamic sql. I also
>have clients in both 10g and 9i and for those in 10g I wanted to include the
>purge command as part of the drop as there is no need for these tables to
>clutter the recycle bin.
>
>1) I'm assuming there is some sort of session variable that tells me the
>major server version?
>

there is a function in dbms_utility
>2) Is this a bad approach? It seems ok given its dynamic sql...
>

It is an EXTREEMLY bad approach to run DDL on the fly, let alone from a trigger.

>thx
>
>Jack
>

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Oct 19 2005 - 17:47:20 CDT