Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple question..I am running a stored procedure from SQL PLUS
for what it is worth, I usually put 'dmbs_output.enable(1000000);' as one of the first line in my procedures as well as 'set serveroutput on'.
Pete Finnigan <pete_at_peterfinnigan.demon.co.uk> wrote in message news:<nsZ8jiADuTc7EwCg_at_peterfinnigan.demon.co.uk>...
> 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?
Received on Wed Aug 08 2001 - 14:41:52 CDT