Re: Convert Stored Procedure to *.SQL
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 05 Feb 2008 16:55:17 -0800
Message-ID: <1202259291.262723@bubbleator.drizzle.com>
Date: Tue, 05 Feb 2008 16:55:17 -0800
Message-ID: <1202259291.262723@bubbleator.drizzle.com>
rzaleski wrote:
> How do I convert a stored procedure to a *.SQL file?
spool c:\temp\myproc.sql
SELECT dbms_metadata.get_ddl('PROCEDURE', '<your proc name here>'); FROM dual;
spool off
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Feb 05 2008 - 18:55:17 CST