Flushing the dbms_output.put

From: <ekophyne_at_my-deja.com>
Date: Wed, 05 Apr 2000 10:11:46 GMT
Message-ID: <8cf3gs$cgp$1@nnrp1.deja.com>

I'm using a CURSOR FOR loop in an anonymous block to perform some fiddly updates to a table. I'm keeping count of the number of iterations of the loop in a PLS_INTEGER variable.

I'd like to use dbms_output.put_line to give me a loop count every 1000 rows. However, I don't see any output until the whole process finishes. That is to say, the output buffer is not flushed until the block exits.

I've tried putting the dbms_output statement inside its own BEGIN & END block, but this has no apparent effect. I've also tried toggling dbms_output.enable/disable. (According to my Steve Feurstein book, dbms_output.disable should force a flush...) but this seems not to work either.

Has anyone found a solution?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 05 2000 - 05:11:46 CDT

Flushing the dbms_output.put_line Buffer...