How do I convert a stored procedure to a *.SQL file?

On Feb 5, 1:43*pm, rzaleski <rzale...@gmail.com> wrote:
> How do I convert a stored procedure to a *.SQL file?

Use other procedures to get it and write it out.

http://download.oracle.com/docs/cd/B...htm#sthref1981

jg
--
@home.com is bogus.
Blame the ERP implementation: http://www.americanlafrance.com/inte...p=4&s=22&a=163

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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On 5 Feb, 21:43, rzaleski <rzale...@gmail.com> wrote:
> How do I convert a stored procedure to a *.SQL file?

Depends on your version of Oracle.

The DBA_SOURCE view may be of use to you.

HTH

-g