Re: Line overflow

kderaedt_at_hotmail.com said...
> Hi,
>
> This is probably a dummy question. I have a script that dumps the
> output of a table to a file. If I executed this script I receive the
> message 'Line overflow'. How can I solve this? This is my sql statement,
> a'm using Oracle 8.1.7.3.
>
> select '#'|| PAP_ADDR ||'#'|| PUSH_ID ||'#'|| DECODE (STATE,0,'No
> State',1,'Accepted',2,'In
> Progress',3,'Rejected',4,'Expired',5,'Cancelled',6,'Delivered',7,'Undelivera
> ble',8,'Pendig',9,'Awaiting Confirm',10,'Timeout',11,'Aborted','NONE')
> ||'#'|| PUSH_INITIATOR ||'#'|| CALLBACKURL ||'#'||
> to_char(to_date('19700101000000','yyyymmddhh24miss')+(TIME_OF_POST /
> 86400),'hh24:mi:ss dd.mm.yyyy') ||'#'||
> to_char(to_date('19700101000000','yyyymmddhh24miss')+(EVENT_TIME /
> 86400),'hh24:mi:ss dd.mm.yyyy') ||'#'|| PAP ||'#'|| PPG ||'#'|| DECODE
> (PRIORITY,1,'High',2,'Medium',3,'Low',99,'Ultrahigh','NONE') ||'#'|| DECODE
> (DELIVERY_METHOD,1,'Confirmed',2,'Prefer Confirmed',3,'Unconfirmed',4,'Not
> Specified','NONE') ||'#'|| DECODE
> (NETWORK_REQUIRED,0,'False',1,'True','NONE') ||'#'|| DECODE
> (BEARER_REQUIRED,0,'False',1,'True','NONE') ||'#'|| NETWORK ||'#'|| BEARER
> ||'#'|| to_char(to_date('19700101000000','yyyymmddhh24miss')+(DELIVER_BEFORE
> / 86400),'hh24:mi:ss dd.mm.yyyy') ||'#'||
> to_char(to_date('19700101000000','yyyymmddhh24miss')+(DELIVER_AFTER /
> 86400),'hh24:mi:ss dd.mm.yyyy') ||'#' from completed_push_tbl;
>
> Thanks
>
> Karel
>

Put a chr(10) - newline - here and there to break the line into multiple lines. You'll need to tell the program that loads this file about the newlines. For example,

select '#' || PAP_ADDR || chr(10) || '#' || PUSH_ID || chr(10) ...

Also, remember to set trimspool on so trailing spaces on each line are eliminated. Otherwise, each line will be right-padded to your linsize width.

-- 
/Karsten
DBA > retired > DBA