RE: Any woraround for this ....?

2002-09-05 Thread Seefelt, Beth
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

RE: Any woraround for this ....?

2002-09-05 Thread Richard Huntley
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

Re: Any woraround for this ....?

2002-09-05 Thread Muthaiah, VSNL
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

RE: Any woraround for this ....?

2002-09-05 Thread Naveen Nahata
: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

RE: Any woraround for this ....?

2002-09-04 Thread Seefelt, Beth
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

Re: Any woraround for this ....?

2002-09-04 Thread Jared Still
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

RE: Any woraround for this ....?

2002-09-04 Thread Manavendra Gupta
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

RE: Any woraround for this ....?

2002-09-04 Thread Robson, Peter
! (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

RE: Any woraround for this ....?

2002-09-04 Thread Jared . Still
-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

Re: Any woraround for this ....?

2002-09-04 Thread Muthaiah, VSNL
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.