RE: Any woraround for this ....?

-----Original Message-----
From: Muthaiah, VSNL [mailto:muthaiah@vsnl.net]
Sent: Thursday, September 05, 2002 1:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Any woraround for this ....?

Thanks. I did as you said but now with the following error. It writes for the first table and then this error crops.

 

SQL> exec extract
BEGIN extract; END;

 

*
ERROR at line 1:
ORA-20001: 1User-Defined Exception
ORA-06512: at "SCOTT.EXTRACT", line 119
ORA-06512: at line 1

 

Am i missing some thing?

 

Rgds,

 

Muths

----- Original Message -----

From: Seefelt, Beth

To: Multiple recipients of list ORACLE-L

Sent: Wednesday, September 04, 2002 7:18 PM

Subject: RE: Any woraround for this ....?

 

Remove all the dbms_output calls and use utl_file.  It should get around this error, and its not possible to get the below error with utl_file so you must have missed something when you tried it the first time.

 

HTH,

Beth

-----Original Message-----
From: Muthaiah, VSNL [mailto:muthaiah@vsnl.net]
Sent: Wednesday, September 04, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Any woraround for this ....?

Hi,

 

I'm writing a procedure/script for extract the data of all the tables in a schema. When I am trying to spool/write into a file, I am getting the following error.

 

ORA-20001: -20000ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
ORA-06512: at "SCOTT.EXTRACT", line 115
ORA-06512: at line 1

First I tried to spool to a file.But got the error line length overflow. I have tried using the UTL_FILE option also. But getting the same error. Can anyone in the list has any work around for this?

 

Thanks in Advance,

 

 

Muths

 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).