Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Anyway way to print while executing procedure ?

Re: Anyway way to print while executing procedure ?

From: <eswar_oracle_at_hotmail.com>
Date: Mon, 22 Feb 1999 07:42:57 GMT
Message-ID: <7ar1q0$eem$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US