Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: Dynamic SQL to disable constraints.

From: Louis Frolio <>
Date: 22 Sep 2004 16:25:55 -0700
Message-ID: <> (Ed prochak) wrote in message news:<>...
> (Louis Frolio) wrote in message news:<>...
> > Daniel Morgan <> wrote in message news:<1095730389.636770_at_yasure>...
> [snip]> >
> > > I want to add my name to the posting by Hans Forbrich.
> > >
> > > I too sometimes cringe at people's use the English but then I expect
> > > more than a few cringe at mine. That said no one here is being paid
> > > to do anything at all. Accept that which is offered with grace.
> >
> > Daniel, although I disagree with your opinion I respect what you have
> > to say because you convey your opinion with respect. Others here are
> > nothing less that than arrogant human beings who in my opinion derive
> > some pleasure out of flaming people. What gets me is that what we do
> > as DBA's is not rocket science, we are simply managing data and using
> > a particular software to do it. I am utterly floored at times when I
> > see these people strut their stuff like they are cock of the walk;
> > again I say this is not rocket science. I want to once gain reiterate
> > that my original post was exclusively about PL/SQL and not about dba
> > best practices. If you read some of the posts to my question,
> > especially the ones where the negativity shines through, you will see
> > the response has nothing to do with PL/SQL.
> Let's see exactly how negative the initial responses were:
> first Ana Dent:
> >"it is failing"
> Too bad you chose not to share with us the actual error message.
> >The output properly displays the "alter datbase ..." command though?
> What "alter DATABASE" command?
> ===
> A backdoor way of asking what the real error was and pointing out a
> typo.
> Boy that was a scathing rebuke! Would you agree that this one is
> neutral? (neither positive nor negative)
> then Sybrand Baker:
> >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.
> ===
> first he noted your solution would work (implying it is a compile time
> problem), hinted at an alternative solution (defferred constraints),
> and ended with a remark about the first solution's ability to enhance
> plant growth. 8^)
> yes the remark might be more diplomatically worded. Okay, let's call
> it negative.
> then Daniel Morgan:
> vString := 'ALTER TABLE job_history DISABLE CONSTRAINT ' || vConName;
> Your usae of the USING clause serves no purpose as vConName is not a
> bind variable and can not be a bind variable.
> ===
> a more detailed response. this is clearly positive.
> then Wario:
> 1. Remove ';' from the end of your string. Execute Immediate fails
> when commands are terminated with ';'.
> ===
> Possibly the answer to your original question, but without the error
> message we don't know. But this too is positive.
> On the negative one, you still got PL/SQL info.
> > I just hope that people
> > can learn to be more sympathetic to others and if they can't say
> > something positive or relevant then they should just keep quiet. Even
> > across cultural boundaries I would hope that this is self evident and
> > within the boundaries of common sense, perhaps I wrong but hopefully I
> > am not.
> >
> > With that said I will drop this.
> >
> > Regards, Louis Frolio
> This is the way of newsgroups. IF you read the news.newusers posting,
> then you might know that you should browse a group for a bit before
> posting. Then you would know the culture of the group. It is not the
> group's responsibility to find multicultural-acceptable responses to
> posts. (especially since that may be impossible.) You would also know
> to search the group for the FAQ to see if it holds the answer to your
> question. And nowadays with GOOGLE and other search engines, you can
> search the group to see if your question was answered before.
> Have you ever dealt with a gruff fellow employee at work? In the
> market? while driving?
> Do you really think newsgroups are any different than those other
> areas of life?
> Have a nice day, and keep posting.
> Ed.

Ed, I applaud you for intervening with a genuine and earnest intent. I had put this issue to rest but I am willing to discuss further. With that said I would like you to re-read Sybrand's first response to my query and in all honesty tell me that he provided a straight answer as it pertained to my PL/SQL question. Yes he did indicate that "execute immediate" is the way to go and I had tried that (see my original post), obviously I had some syntax wrong and I was hoping that someone in the group could show me the error. What he should have said was that my code was indeed erroneous and I that I needed to look more carefully at what I did. As you state "hinted at an alternative solution (deferred constraints)" is completely irrelevant to my initial query and as far as I am concerned should have been a side note to his response if he felt compelled to share his position. I have been using News Groups for well over 7 years, do a search on my last name and you will find posts dating back to 1997. Throughout that time I have been constantly amazed at the overt hostility to persons who post what some "perceive" to be stupid questions. Anyone who goes to college learns that there exists no such thing as a stupid question. Even if someone does post a trite question do others need to flame that person? Doesn't that indeed chew up more bandwidth, the very thing the flamers are trying to conserve? With all this said I really think that certain people in this newsgroup really need to chill out and have more patience with others. Mr. Bakker is very knowledgeable, there is no debate here. However, it does not give him the right to lash out at people when "he feels" a question or method or whatever is irrelevant to him or his cronies. I do not have a problem with any of the other posts in this thread, so I am not sure why you quoted others. Finally, with all this said I would like to challenge all those "aggressive drivers" in this newsgroup to just show a bit more compassion and patience with others. If you have something to share do it with grace and sincerity.

Regards, Louis Frolio

P.S. I recently posted a question on replication; let's hope no one out there finds it irrelevant :) Received on Wed Sep 22 2004 - 18:25:55 CDT

Original text of this message