Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Data conversion

Data conversion

From: Yigal Ran <>
Date: 10 Aug 00 11:48:41 EDT
Message-Id: <>

  Can any one tell me what are the steps to convert data from Lotus Notes=  to

TIA Yigal

Get free email and a permanent address at

 Date: Thu, 10 Aug 2000 12:07:56 -0400
 Subject: Re: serverouput buffer overflow

--0__=W26n5WktCiRuAPEzxxlPMhtp22QN6fp8gZvolmwD0Tr6doq4ocbw1U3P Content-type: text/plain; charset=us-ascii Content-Disposition: inline


I don't think there is a way round the buffer limit, I take it you are using DBMS_OUTPUT to do this.
If you are on 8.x have you considered utl files, there's no limit execpt what space you left on your OS

hope it helps

"Boivin, Patrice J" <> on 08/10/2000 12:31:52 PM

Please respond to

To: Multiple recipients of list ORACLE-L <> cc: (bcc: Brian McQuillan/GELCO)

Subject: serverouput buffer overflow

Does anyone know how I can work around the 1000000 limit for server output?

I have a cursor that makes a list of all the indexes in a database, then I use that to generate sql to file to analyze them in turn plus store their sizing info into a separate table.

Unfortunately there is so much information generated in the cursor that when I use dbms_output to produce the SQL, I reach the limit.

Sqlplus only seems to spool once the command has finished, in this case until the whole PL/SQL loop has finished.

I would prefer not having to break up the job into smaller cursors.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst --0__=W26n5WktCiRuAPEzxxlPMhtp22QN6fp8gZvolmwD0Tr6doq4ocbw1U3P

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

Author: Boivin, Patrice J

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




 From: "Rachel Carmichael" <>
 Date: Thu, 10 Aug 2000 16:02:39 GMT
 Subject: Re: serverouput buffer overflow

write a pl/sql procedure and use the utl_file procedure to write to a file 
on disk

>From: "Boivin, Patrice J" <>
>To: Multiple recipients of list ORACLE-L <>
>Subject: serverouput buffer overflow
>Date: Thu, 10 Aug 2000 08:31:53 -0800
>Does anyone know how I can work around the 1000000 limit for server output?
Received on Thu Aug 10 2000 - 10:48:41 CDT

Original text of this message