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
If I just echo (without the file) it looks like