From: nsouto@optushome.com.au.nospam (Nuno Souto)
Newsgroups: comp.databases.oracle.server
Subject: Re: Simple question..I am running a stored procedure from SQL PLUS
Organization: D.C.S. P/L
Message-ID: <3b713773.2813960@news>
References: <92a0e580.0108071547.1fc737a4@posting.google.com>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 14
Date: Wed, 08 Aug 2001 13:08:39 GMT
NNTP-Posting-Host: 203.164.180.25
X-Complaints-To: abuse@optushome.com.au
X-Trace: news1.blktn1.nsw.optushome.com.au 997276119 203.164.180.25 (Wed, 08 Aug 2001 23:08:39 EST)
NNTP-Posting-Date: Wed, 08 Aug 2001 23:08:39 EST


On 7 Aug 2001 16:47:25 -0700, debo_nair@yahoo.com (Manoj Nair) wrote:

>so i do a SQL> EXEC my_sp..I have dbms_output statements in code and i
>have also set serverout on ..but it doesn't print the messages what am
>i missing?

I assume by printing you mean display on screen?  If so, make sure
that you use dms_output.put_line and that the set serveroutput is done
immediately before the exec.  With 8.1.6 in NT, it turns itself off
with monotonous regularity...

Cheers
Nuno Souto
nsouto@optushome.com.au.nospam