Re: How to export stored procedure

From: Steve Long <answers_at_ix.netcom.com>
Date: 1996/06/04
Message-ID: <4p1tv4$t12_at_dfw-ixnews9.ix.netcom.com>#1/1


In <31B37D08.148C_at_itsi.disa.mil> Bob Yeh <yehr_at_itsi.disa.mil> writes:
>
>Hi,
>
>I am trying to move stored procedures from one user to another. EXP
 does
>not have the option to export just that. What can I do?
>
>Bob.

Bob,

I wrote this SQL*Plus script on the fly, test it out:

set echo off feedback off verify off head off pagesize 0 lines 65 SPOOL output.pls
select

    text
from

    dba_source
where

    owner = upper('&USER') -- or use a literal here order by

    line
group by

    type
    ,name
/
SPOOL off
exit Received on Tue Jun 04 1996 - 00:00:00 CEST

Original text of this message