Re: Simple question..I am running a stored procedure from SQL PLUS

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 08 Aug 2001 13:08:39 GMT
Message-ID: <3b713773.2813960@news>

On 7 Aug 2001 16:47:25 -0700, debo_nair_at_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_at_optushome.com.au.nospam Received on Wed Aug 08 2001 - 08:08:39 CDT