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

Any woraround for this ....?

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

RE: Any woraround for this ....?

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

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
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

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.