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

Home -> Community -> Usenet -> c.d.o.tools -> Re: convert to stored procedure + NDS

Re: convert to stored procedure + NDS

From: <yadasiri_at_gmail.com>
Date: 6 Mar 2007 11:15:28 -0800
Message-ID: <1173208513.468832.188220@h3g2000cwc.googlegroups.com>


On Mar 6, 2:05 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu
> (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 - 13:15:28 CST

Original text of this message

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