Re: dbmf_output.put_line question

"Ubiquitous" <weberm_at_polaris.net> wrote in message news:au7j6s$4fm$1_at_news.utelfla.com...
> I am encountering a really weird problem and wonder if someone
> can suggest what might be causing it...
>
> I created some stored procedures and scripts in PL/SQL which
> use dbmf_output.put_line to display messages when they are run.
> The scripts and prcos both use dbmf_output.enable and are invoked
> in a UNIX shell script which pipes the output to a log file
> which is then emailed to the analyst and DBA as a daily report
> on that night's run of the job.
>
> I ran and tested the job in a TEST instance to my satisfaction
> (it runs with the put_line messages just fine), but when I copied
> the scripts to our PROD instance (only making changes so it reads
> the correct tables) and ran it, the display statemnets no longer
> appear. Even more puzzling is that if I run the scripts in a SQL*PLUS
> session on both instances, the display statemnets are produced!
>
> I am going to assume there is something different about the way the
> two instances are configured but have no clue as to what it could
> be. Does anyone have any ideas?
>
> Thank you!
>
>

Your test instance must have a login.sql somewhere which has set serveroutput on
in it,.
your prod instance doesn't enable serveroutput by default

How you managed to rename the package dbms_output to dbmf_output, and still have a working system is a mystery, or Freud must govern your typing.

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address