AnsweredAssumed Answered

Output from Unix job doubled in attached report

Question asked by Brett_Barnhart_453 on Jan 15, 2014
Latest reply on Jan 27, 2014 by Brett_Barnhart_453

I'm running V10

I have a pretty simple job that dumps output from a PL/SQL procedure into a file and then attaches that file to the job and emails it via notification.


All works beautifully except that the output is doubled.  If I simply echo it to the normal report, it looks right.

I'm trying to figure out why this is doubling..  any ideas?

echo "Start" >> &outputfile

 "Some PL/SQL     /"| sqlplus -s $login >> &outputfile

:REGISTER_OUTPUTFILE "&outputfile", "N"

I've been using this in V8 quite a bit... so I don't know why this is doubling in V10

The output I get looks like


Start

Data

Data


If I just echo (without the file) it looks like

Start

Data


Outcomes