Re: save package to file in sqlplus?

You need to edit it to add a / at the end, and CREATE OR REPLACE at the top of the header and body.

spool c:\pkg.sql
set pagesize 2000
set linesize 140
select text
from all_source
where name = 'PACKAGENAME'

   and owner = 'OWNER'
order by type,line
/
spool off

John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL
<tcblue_at_my-deja.com> wrote in message news:95hnf6$hvo$1_at_nnrp1.deja.com...
> Hi,
> I am working remotely, and only have access to sqlplus. I need to be
> able to retrieve/edit/re-load/compile a package on a remote server. I
 can:
> describe PKG_NAME;
> fine, but i need the actual package itself so I can re-load/compile when
> i'm done editing. Is there some kind of dump command to dump it to a
> file (or like spool).... How do i access the package? a select
> statement? also, I'm not sure where packages are stored... Are under a
> system table or package table? Please let me know if you have the
> answers to these quesetions,
>
> -Patrick T.-
> tcblue82_at_yahoo.com
>
>
> Sent via Deja.com
> http://www.deja.com/
>
Received on Sat Feb 03 2001 - 14:33:37 CST