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
HI
in your sqlplus session type
SQL> set serveroutput on size 1000000
SQL> exec my_sp....
then you will see output.
cheers
Pete Finnigan
Pentest Limited
In article <tn28m3inctej08_at_corp.supernews.com>,
tskumar011_at_rediffmail.com writes
>PRINTER?
>
>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?
>
>
>--
>Posted via CNET Help.com
>http://www.help.com/
-- Pete FinniganReceived on Wed Aug 08 2001 - 07:49:56 CDT