Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Execute Immediate DDL & DML
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. Received on Sat Feb 10 2007 - 14:01:48 CST