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>


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.org
Received on Tue Feb 05 2008 - 18:55:17 CST

Original text of this message