Re: display message/comments while executing a procedure

From: Xavier Neys <neysx_at_xs4all.nl>
Date: Wed, 10 Oct 2001 10:25:50 +0200
Message-ID: <9q1190$sk4$2@news1.xs4all.nl>

Hi,

Use the DBMS_OUTPUT package.
Please note that ALL messages will be displayed AFTER the procedure has finished its work.

Other solutions involve writing to a pipe (DBMS_PIPE) or to a file (UTL_FILE) but will require more work on your part to read the messages will the procedure executes.

HTH

--
Today, Tomorrow, Together
The DOC
(The Dutch Oracle Company)
www.thedoc.nl
Xavier Neys



"Parvinder Singh Arora" <minkuarora_at_yahoo.com> wrote in message news:e7c950a4.0110100024.2f1a842c_at_posting.google.com...


> Hi all

>

> While a procedure is executing (thru sqlplus) , i want to display some

> message/comments on sqlplus ..what statement do i use in the procedure

> ?

>

> Thanks

>

> ~Parvinder

Received on Wed Oct 10 2001 - 03:25:50 CDT