RE: A Basic PL/SQL Question
Another option is to create a table with a large varchar2 column and insert the data row by row. You can then spool a SELECT from that table to a file. e.g. create table hold_output (mytext varchar2(4000) tablespace ts_small; -Original Message- Sent: Tuesday, March 27, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't enough to print output for my entire table. Is there another way to display data? Or is there some way to increase the maximum? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: A Basic PL/SQL Question
Hi ... you can go for UTL FILE feature of Oracle PL/SQL, it is very handy while handling large amount of data that DBMS_OUTPUT can't handle due to the buffer size constraints. Cheers, Bagchi. On Wed, 28 March 2001, "Miller, Jay" wrote: Another option is to create a table with a large varchar2 column and insert the data row by row. You can then spool a SELECT from that table to a file. e.g. create table hold_output (mytext varchar2(4000) tablespace ts_small; -Original Message- Sent: Tuesday, March 27, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't enough to print output for my entire table. Is there another way to display data? Or is there some way to increase the maximum? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: A Basic PL/SQL Question
Use the UTL_FILE package and write the results to a temporary file. Eric -Original Message- Sent: Tuesday, March 27, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't enough to print output for my entire table. Is there another way to display data? Or is there some way to increase the maximum? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: A Basic PL/SQL Question
Bill, The version 8 PL/SQL manual states: Messages sent using the DBMS_OUTPUT are not actually sent until the sending subprogram or trigger completes. There is no mechanism to flush output during the execution of a procedure. You may want to try using the file i/o facility provided by the UTL_FILE package - not as convenient, but should handle all of your table. Maybe use DBMS_OUTPUT to indicate when file has been written? Ron Morton Union Switch Signal Inc [EMAIL PROTECTED] -Original Message- From: Carle, William T (Bill), NLCIO [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Subject: A Basic PL/SQL Question Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't enough to print output for my entire table. Is there another way to display data? Or is there some way to increase the maximum? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: A Basic PL/SQL Question
Bill, Try pushing the output directly to a file using calls to the Utl_File supplied package. That would allow you unlimited spooling capacity. If you really want to use DBMS_Output, you might try (but I don't know if it would work) to call DBMS_Output.Disable then DBMS_Output.Enable(100) every once in a while in a loop in your procedure. That would close the buffer, then open it with a new million character capacity (I think). Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Carle, William T (Bill), NLCIO Sent: Tuesday, March 27, 2001 3:09 PM To: Multiple recipients of list ORACLE-L Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't enough to print output for my entire table. Is there another way to display data? Or is there some way to increase the maximum? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).