Re: Convert Stored Procedure to *.SQL

From: DA Morgan <>
Date: Tue, 05 Feb 2008 16:55:17 -0800
Message-ID: <>

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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Feb 05 2008 - 18:55:17 CST

Original text of this message