Re: Simple question..I am running a stored procedure from SQL PLUS
From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 8 Aug 2001 17:41:44 GMT
Message-ID: <Xns90F750635E947gnuegischgnueg_at_130.133.1.4>
Date: 8 Aug 2001 17:41:44 GMT
Message-ID: <Xns90F750635E947gnuegischgnueg_at_130.133.1.4>
debo_nair_at_yahoo.com (Manoj Nair) wrote in
>> >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?
>>
>> Have you SET SERVEROUTPUT ON in the sql plus prompt?
>>
>> Rene
>
>YES I HAVE SET SERVEROUTPUT ON in the sql plus prompt....
Oh, my dear, yes, you have written it clearly. I must have overlooked it. I am feeling quite guilty.
Rene
-- Recherchen im Schweizerischen Handelsamtsblatt: http://www.adp-gmbh.ch/SwissCompanies/Search.php3Received on Wed Aug 08 2001 - 19:41:44 CEST