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_at_bubbleator.drizzle.com>
Date: Tue, 06 Mar 2007 11:05:55 -0800
Message-ID: <1173207953.214487_at_bubbleator.drizzle.com>
[Quoted] 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.
[Quoted] 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.orgReceived on Tue Mar 06 2007 - 20:05:55 CET