SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

spool output having duplicate line when executes from unix shell script

bhaskar_subbiahDec 13 2016 — edited Dec 13 2016

Hi Experts,

Here is an issue when i run a oracle script file through unix script and spool to output file. Below is the result in the output spool file.

COUNT VALIDATION

********************************************************

COUNT VALIDATION FOR THE TABLE DW_USER_DOMAIN_OPTIN_DIM

********************************************************

SOURCE_COUNT_ 45682267

TARGET_COUNT_ 46280343

RESULT_IS_

SOURCE AND TARGET COUNT MISMATCH

RESULT_IS_

SOURCE AND TARGET COUNT MISMATCH

I have highlighted lines which are getting repeated. I want the line to appear only one time. when i run the same query in oracle TOAD i am dont see lines are getting duplicated. Only when i run from shell script i am facing this issue.

RESULT_IS_

SOURCE AND TARGET COUNT MISMATCH

This is not only with one script but output of all scripts are having this line repeated. So please advise how to avoid duplicating the line. Any property to set?

If any further info needed please let me know.

Regards

Bhaskar.S

This post has been answered by John Thorton on Dec 13 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2017

Added on Dec 13 2016

8 comments

844 views