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: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 06 Mar 2007 11:05:55 -0800
Message-ID: <1173207953.214487@bubbleator.drizzle.com>


yadasiri_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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Mar 06 2007 - 13:05:55 CST

Original text of this message

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