dbmf_output.put_line question

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! Received on Mon Dec 23 2002 - 12:04:12 CST