Re: set serveroutput on

I got this one wrong. I did some further research and discovered that some
information that I had been given a few years ago was incorrect. That information had led me to believe that dbms_output was layered on top of dbms_pipe. I've done some more research and found out that this is incorrect
and that dbms_output is limited a single session.

Therefore, the real answer is simply to use dbms_pipe if you want to write
information in one process and read it in another.

Thanks to those who pointed out this error on my part

Ken

Kenneth C Stahl wrote:

> Are you trying to use dbms_output inside the pl/sql? If so, what you really
> need to do is write a listener which will perform a dbms_output.get_line to
> retrieve the data from the implicit pipe that dbms_output uses.
>
> However, I'd recommend that you do not use dbms_output in a pl/sql block
> that is embedded in an OCI program unless you know absolutely that yours is
> the only program that will ever use dbms_output. The moment you create a
> listener it will received everything written to dbms_output no matter what
> program puts it there. You'd be better off using dbms_pipe and having an
> implicit pipe. That way when you can listen just for one particular pipe
> identifier.
>
Received on Thu Aug 19 1999 - 06:40:53 CDT