Re: Can print to file in PL/SQL?

Craig Harper (caharper_at_hooked.net) wrote:
: Why can't you just turn the spooler on give it a filename and then spool
: off. use the putline ect.
: Sorry if this is a dumb comment.
: Craig Harper

No it's not a dumb comment. Everyone please forgive me for not painting a complete picture. I assumed that the question was general that I didn't need to specify much more than I had.

The situation is that I'm calling an Oracle stored procedure from within a C++ program (using Persistence(R) software...). The problem was that I was receiving a value/null error from Oracle. I wanted to see what the Oracle stored procedures "thought" I was passing to it. I tried the dbms_output.put_line() calls, but it didn't print out. I was sure that I could print the parameter values to a file and view them from there. But I think it's hopeless. I'll drop this obsession now.

Thanks everyone for the help.

--
****
Jennifer L. Archie
U S WEST Technologies
PSRP -- Public Service Reengineering Project
Office: 303-624-4196

E-mail: jarchie_at_lookout.ecte.uswc.uswest.com
WWW: http://ivarsrv.ecte.uswc.uswest.com/Personnel/jarchie.html