From: Ed Jennings Subject: Help with DBMS_OUTPUT Date: 1997/03/03 Message-ID: <331B7CA5.7E58@dca.net>#1/1 Organization: DCANet http://www.dca.net/ Newsgroups: comp.databases.oracle.misc I'm using DBMS_OUTPUT in a stored procedure that print a key value after doing some computations and an insert. When I run this procedure from SQLPlus, I get no output until the stored proc is finished. I then get pummelled with a few hundred lines of output. The stored proc takes about 15 minutes to execute, therefore I can only assume that the output is being buffered somehow. Does anyone know if this is the case, and if there is a way to turn it off? I want to monitor the progress during runtime, and currently the output is of little use. -- ~~~~~~~~~~~~~~~~~~~~~~~~~ jennings@dca.net