Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Anyway way to print while executing procedure ?
Hi
You can keep the procedure in a Script file and spool it
you can try this way
SPOOL c:\test.txt;
PROMPT PROMPT Procedure is updating !!!!!
Exec procedure;
PROMPT PROMPT Procedure is completed
Spool Off;
Hope it will work.
Regards
Eswar
In article <36D29F8E.6B59200B_at_nus.edu.sg>,
Jeremy <scijr_at_nus.edu.sg> wrote:
> 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.
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 01:42:57 CST