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
Title: Message
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
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
You can use the sqlplus parameter LINESIZE to specify the
size of each line for output. I have used it in the past with lengths of
5000 and more, and it has worked, including spooling to files.
The only drawback in this case is that it adjusts each line
to LINESIZE (adds spaces to the right where
! (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.
10 matches
Mail list logo