X-InterChange-Posted-By: mromka@MailAndNews.com
Date: Wed, 10 Oct 2001 08:08:23 -0400
Sender: Roman Mirzaitov <mromka@MailAndNews.com>
From: Roman Mirzaitov <mromka@MailAndNews.com>
Newsgroups: comp.databases.oracle.server
X-EXP32-SerialNo: 50000000
Subject: RE: display message/comments while executing a procedure
Message-ID: <3BCB14F6@MailAndNews.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: InterChange (Hydra) News v3.61.08
NNTP-Posting-Host: 199.29.68.123
X-Trace: corp.newsgroups.com 1002715052 199.29.68.123 (10 Oct 2001 06:57:32 -0500)
Lines: 28
X-Comments: This message was posted through Newsfeeds.com
X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support,  spam or any illegal or copyrighted postings.
X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!!
X-Report: Please report illegal or inappropriate use to <abuse@newsfeeds.com>
X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS)
Organization: Newsfeeds.com http://www.newsfeeds.com 80,000+ UNCENSORED Newsgroups.
Path: news.easynews.com!easynews!news.he.net!feeder.via.net!local-out2.newsfeeds.com!corp.newsgroups.com
Xref: easynews comp.databases.oracle.server:120798
X-Received-Date: Wed, 10 Oct 2001 06:33:16 MST (news.easynews.com)

Hi,

DBMS_OUTPUT built-in package will help you.
And check whether SQL*Plus serveroutput option is ON.

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


>===== Original Message From minkuarora@yahoo.com (Parvinder Singh Arora) 
=====
>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



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----
