Re: HELP: Output from within Stored Procedure???

Sameer,

Even dbms_pipe will not solve your problem, since the fundu idea is to print out the literal and if we use dbms_pipe, we would need to use spool it out to a file. For this we would need to use dbms_output - back to square 1. Another disadvantage of using dbms_pipe is that one would need to read the pipe continously; else the processing sort of stops, since that buffer is full and no output can be written on it.

The quick and dirty soln, which I came across, is to say dbms_output.enable; This 'tells' Oracle that it has re-initialize the SGA and thereby clear the buffer. In effect, after dbms_output.put_line or a couple of them (based on your set serverout size nnnn), do the dbms_output.enable.

It is working for me fine, so far. If I come across any glitches, I shall keep this newsgroup updated.

Best,
Magesh (magesh_at_pacific.net.sg) Received on Thu May 09 1996 - 00:00:00 CEST