Re: Dynamic SQL to disable constraints.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 19 Sep 2004 19:57:08 -0700
Message-ID: <1095649099.519270@yasure>

Louis Frolio wrote:

> Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<4s7mk0ptg22ffj9a3071g4b8u69eof5hvv_at_4ax.com>...
> 

>>On 17 Sep 2004 05:51:55 -0700, froliol_at_yahoo.com (Louis Frolio) wrote:
>>
>>
>>>I think that I may need to employ
>>>dbms_sql but I am not sure.
>>
>>execute immediate works without problem.
>>I would urge you to look into better solutions, like to find out
>>whether you can set the constraints to deferred.
>>This method is, ahem, yes: crap.

> 
> 
> 
> You should at least have the courtesy to explain why the method employed is crap.

Crap may be a bit too harsh a word ... perhaps doo doo would be better.

The point being that there is a proper method, deferred constraints, for accomplishing the goal. And if you can use it ... a kludge using NDS is just that, a kludge. Not to mention it wrecks heck on a lot of resources so it won't perform or scale well.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sun Sep 19 2004 - 21:57:08 CDT