Re: convert to stored procedure + NDS
Date: 6 Mar 2007 11:15:28 -0800
On Mar 6, 2:05 pm, DA Morgan <damor..._at_psoug.org> wrote:
[Quoted] > yadas..._at_gmail.com wrote:
> > Hi,
> > I have a multiple of large .sql scripts that I would like to convert
> > into stored procedures. Is there a clever way or an existing script I
> > can use to find/replace multiple DDL statements in each sql script
> > like:
> > CREATE SEQUENCE BILL_SEQ
> > START WITH 0
> > INCREMENT BY 1
> > NOCACHE
> > NOCYCLE
> > /
> > with
> > EXECUTE IMMEDIATE 'CREATE SEQUENCE BILL_SEQ '||
> > ' START WITH 0'
> > ' INCREMENT BY 1 '||
> > ' NOCACHE '||
> > ' NOCYCLE';
> > Thank you very much.
> Converting the above to a stored procedure, generically speaking, would
> be a horrible idea. In fact doing it with NDS is a horrible idea too.
> What is the business case?
> Daniel A. Morgan
> University of Washington
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Thanks for your reply, Daniel.
I have to run the scripts through ODBC so it'll be helpful if I can get it into the form of a stored procedure. Received on Tue Mar 06 2007 - 20:15:28 CET