From: rene.nyffenegger@gmx.ch (Rene Nyffenegger) Newsgroups: comp.databases.oracle.tools Subject: Re: Simple question..I am running a stored procedure from SQL PLUS Date: 8 Aug 2001 17:41:44 GMT Lines: 22 Message-ID: References: <92a0e580.0108071547.26d135af@posting.google.com> <92a0e580.0108080708.221bbd92@posting.google.com> NNTP-Posting-Host: pop-mu-16-1-dialup-49.freesurf.ch (194.230.114.49) X-Trace: fu-berlin.de 997292504 6406044 194.230.114.49 (16 [82536]) User-Agent: Xnews/4.01.30 debo_nair@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.php3