Title: Message
What
is the line of code at line 119?
Beth
-Original Message-From: Muthaiah, VSNL
[mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:58
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Any woraround for this ?
Thanks. I did
1:58
AMTo: Multiple recipients of list ORACLE-LSubject: 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 extractBEGIN extract;
END;
*ERROR at line 1:ORA-20001: 1User-Defined
recipients of list ORACLE-L
Sent: Thursday, September 05, 2002 7:03
PM
Subject: RE: Any woraround for this
?
Muths,
What
is the purpose of having the table data dumps? If you're just going to
use them to load data back into Oracle, why
not
just use table level
:08
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Any woraround for this ?
Richard,
You are right. But for me, the organization for
which I work, has around 20 branches and not all the branches has support
person. So It will be difficult for us to get the DMP's
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: -2ORA-2: ORU-10028: line length
overflow, limit of 255 bytes per lineORA-06512: at "SCOTT.EXTRACT", line
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 6:48
AMTo: Multiple recipients of list ORACLE-LSubject: 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
Muths,
I hope I'm not beginning to sound like a nag, but PL/SQL is
not really a great tool for what you're trying to do.
I *like* PL/SQL, but it does have its limits. This is one of them.
What you're trying to do in PL/SQL can be done rather simply
in Perl. The heart of a program to do
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:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Any
! (Yes yes, it could probably be all
worked out, but lets save some time here...)
peter
edinburgh
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2002 17:14
To: Multiple recipients of list ORACLE-L
Subject: Re: Any woraround for this ?
Muths
-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Any woraround for this ?
Hee hee hee! I just LOVE that phrase 'That''s all there is to it'! (notice
my correct SQL syntax here...)
Ummm, errr, well, not quite all. Just a tiny
e
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.
11 matches
Mail list logo