Re: convert to stored procedure + NDS
Date: Tue, 06 Mar 2007 11:05:55 -0800
[Quoted] yadasiri_at_gmail.com wrote:
> 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
> CREATE SEQUENCE BILL_SEQ
> START WITH 0
> INCREMENT BY 1
> 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