Re: Anyway way to print while executing procedure ?

From: ydias <ydias_at_hotmail.com>
Date: Sun, 7 Mar 1999 15:37:56 +0100
Message-ID: <7bu3is$e9n$1@front7.grolier.fr>

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 ... Received on Sun Mar 07 1999 - 08:37:56 CST