Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLPlus: Spool is wrapping lines at 120 chars when linesize = 1000

605073Oct 24 2007 — edited Dec 10 2008
I have the following sqlplus script for exporting package spec and body source to separate files (SQL Developer makes doing so tiresome).
The idea is it can be run from sqlplus like this:

@export Owner PackageName

Its working fine except it wraps lines at 120, even though I am explicitly setting linesize to 1000. Can anyone see why this is happening?

code:
set define on
set verify off
set heading off
set serveroutput off
set pause off
set feedback off
set time off
set linesize 1000
--
-- Package Spec
--

spool "&2..PKS"
--
select 'CREATE OR REPLACE ' from dual
/
select text
from dba_source
where owner = '&1' AND NAME = '&2' AND Type = 'PACKAGE'
/
--
spool off
--
-- Package Body
--

spool "&2..PKB"
--
select 'CREATE OR REPLACE ' from dual
/
select text
from dba_source
where owner = '&1' AND NAME = '&2' AND Type = 'PACKAGE BODY'
/
--
spool off
--
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2009
Added on Oct 24 2007
5 comments
17,454 views