Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL to disable constraints.

Re: Dynamic SQL to disable constraints.

From: Louis Frolio <froliol_at_yahoo.com>
Date: 19 Sep 2004 19:19:32 -0700
Message-ID: <94c28610.0409191819.ed291b1@posting.google.com>


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. Received on Sun Sep 19 2004 - 21:19:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US