Re: How to export a PLSQL Package on ascii file??

Pierre wrote in message <2cah1.1043$8F2.3188064_at_news21.bellglobal.com>...
>
>Brevet-Lepreux wrote in message <01bd986d$d38703a0$010b17ac_at_mbl>...
>>I need a script to export a package and package body into an ascii file.
>>
>
>Hi,
> Simple.
>
> Set head off feedb off lines 254
> spool pck.lis
> select text from user_source where name='<PACKAGE NAME>';
> spool off
>

And don't forget about
1. ... and TYPE='PACKAGE BODY' in where clause (for package body

   or TYPE='PACKAGE' for package specification). 2 'order by line' after where clause !!!!

Piotr
--
 Piotr Kolodziej
 <pkol_at_otago.gda.pl>

• My voice. My private opinion. *