Re: Anyway way to print while executing procedure ?

Bonsoir,

nerver use dbms_output feature to trace your pending work for these two simple reason: 1 - You wont get what you'r expecting simply because the dbms_output feature uses bufferized output, this buffer is fetched once at the end of your procedure when all the work is done. 2 - The "set serverouput on size 60000" (check doc for max value allowed(should be 1000000 )) set the maximum size of this buffer, so if you plan to use the dbms_output facility for bigger work, be sure that your output text length multiplied by the number of call to the dbms_output never exceed this size, otherway it'll result in an buffer error that could break your work.

Try using utl_file instead or commit each 200 lines and insert traces in a dummy table that you can select in another session.

In article <36e383d1.3293848_at_news.calvacom.fr>,   jbmorla_at_calva.net (JEAN BENOIT MORLA) wrote:
> On Sun, 7 Mar 1999 15:37:56 +0100, "ydias" <ydias_at_hotmail.com> wrote:
> Actually, given the size of your table, you might run out of output
> space.
> set serveroutput on size 60000
> to make sure.
> Also if you want to keep written track of the output, try using the
> utl_file package.
>
> >HI,
> >
> >Jeremy a écrit dans le message <36D29F8E.6B59200B_at_nus.edu.sg>...
> >
> >>Hi, I really hope someone can help
> >>
> >>I have created a procedure containing a cursor which updates a table
> >>containing about 7000 records. Due to the large number, upon executing
> >>the procedure in the script, I could not trace if the process is running
> >>or stopped.
> >>
> >>So is there a way where I can print a counter for example in SQL*PLUS so
> >>that I noe the procedure is executing smoothly. Thank you.
> >
> >
> >To print smoething during execution :
> >1- the server output must be on :
> > SET SERVEROUTPUT ON
> >2- You can write inside your cursor loop:
> > DBMS_OUTPUT.PUT_LINE('My coursor is here' || TO_CHAR(Counter));
> >
> >This will print a line ...
> >
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 10 1999 - 16:41:08 CST