Line overflow

From: kderaedt <kderaedt_at_hotmail.com>
Date: Mon, 14 Apr 2003 22:34:11 +0200
Message-ID: <3e9b1b40$0$24135$ba620e4c@reader0.news.skynet.be>

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 Received on Mon Apr 14 2003 - 15:34:11 CDT