Title: Message
|
What
is the line of code at line 119?
Beth
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 -----
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
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
|
