Re: SQR, PL/SQL and DBMS_OUTPUT

[Eric Dimick Eastman <erice@ONTKO.COM>]

Gini,

If you cannot change the call to DBMS_OUTPUT, I believe that you are
sunk.  I spent some time trying to capture the output of a procedure
call with no luck.

Another thing you can try that works well in both SQL*Plus and SQR is
DBMS_PIPE.  Basically you open a pipe with a certain name and put
messages into one end of the pipe.  Then any process connected to the
database can pull the messages out the other end.  As with Tony's table
approach you would have concurrency problems; although, you should be
able to solve them.

Good Luck,
Eric

Tony DeLia wrote:
>
[Snip a very sensible and workable solution using temporary tables.]
> PS - SQR is pretty versatile!
>
> Gini Potts (ginip) wrote:
> >
> > I want to execute an PL/SQL program from an SQR.  This particular PL/SQL
> > program uses calls to DBMS_OUTPUT to write a report.  When I run this report
> > through SQLPlus, I SET SERVEROUTPUT ON and spool the output to a file.  Is
> > there a way to access the serveroutput with an SQR, or am I sunk?
> > (Unfortunately, changing DBMS_OUTPUT to UTL_FILE is not an option.)
> >
> > Thanks.
> >
> > Gini
>
> --
> Tony DeLia
> AnswerThink Consulting Group
> PeopleSoft Solutions Practice - Delphi Partners
> tdelia@erols.com