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 08:33:38 GMT Lines: 11 Message-ID: References: <92a0e580.0108071547.26d135af@posting.google.com> NNTP-Posting-Host: pop-zh-19-2-dialup-225.freesurf.ch (194.230.222.225) X-Trace: fu-berlin.de 997259618 6479421 194.230.222.225 (16 [82536]) User-Agent: Xnews/4.01.30 >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 -- Recherchen im Schweizerischen Handelsamtsblatt: http://www.adp-gmbh.ch/SwissCompanies/Search.php3