Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple question..I am running a stored procedure from SQL PLUS

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

From: Pete Finnigan <pete_at_peterfinnigan.demon.co.uk>
Date: Wed, 8 Aug 2001 13:49:56 +0100
Message-ID: <WcEw$JA0VTc7Ewnm@peterfinnigan.demon.co.uk>

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 Finnigan
Received on Wed Aug 08 2001 - 07:49:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US