Re: Execute Immediate DDL & DML

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 11 Feb 2007 10:16:40 -0800
Message-ID: <1171217799.53537@bubbleator.drizzle.com>

00steve wrote:
> On 9 Feb, 16:42, DA Morgan <damor..._at_psoug.org> wrote:

>> 00steve wrote:
>>> Thanks for your reponse. I have used SET ROLE NONE, and can still
>>> select from user_sequences table.
>> I'm with Frank. This is dangerous and guaranteed to fail. The only
>> question is "When?"
>>
>> What is the business case?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

>
> Hi, thanks for all replies. I should have really explained; I'm really
> more concerned with learning PL/SQL, the script will never be used by
> other developers. I am just interested in having a procedure call that
> I can use in build scripts to calibrate sequences after table inserts
> (letter management system which ships with some standard templates).
> As the sequence and tables are completely separate within the DBMS
> there is always going to be the risk that the function be misused.
> None-the-less, I still feel that it is a useful procedure and learning
> experience. I have found your comments insightful.

I agree with what Frank wrote but I want to play devil's advocate for a moment.

What is the value in learning bad practices?

You could easily spend the next ten years of your life learning things of importance to managing databases. Why spend five minutes on something that will not work except in a stand-alone, single-user, environment?

If you want to reset a sequence ...
http://www.psoug.org/reference/sequences.html and scroll to "Sequence Resets"

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Feb 11 2007 - 12:16:40 CST