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

Hi

No i meant what i typed, its worth setting the default buffer size to 1000000, the maximum, otherwise it remains at the default size of 20000 bytes.

You can do either syntax, but if your output exceeeds the minimum it will just stop.

cheers

Pete
Pentest Limited

In article <99ab87b0.0108080450.6de41c62_at_posting.google.com>, Tom Best <tombest_at_firstusa.com> writes
>I hope you mean you did:
>
> set serveroutput on
>
>right?
>
>debo_nair_at_yahoo.com (Manoj Nair) wrote in message news:<92a0e580.0108071547.1fc7
>37a4_at_posting.google.com>...
>> 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?
 

-- 
Pete Finnigan