Logging .sql file output to log file in shell script

Question

I have an sql file being called from shell script, and I want to capture the output of the execution into a log file. I am trying to capture by appending redirecting to log file like this >> log.txt but it is not working.

What do I need to do to fix it?

sqlplus -s ${USER}/${PWD}@${DATABASE} << EOF
@${LOADDIR}/VV_validation.sql
EOF'

There's at least a decent chance that sqlplus -s ${USER}/${PWD}@${DATABASE} << EOF >> log.txt 2>&1 would do the job. The 2>&1 sends standard error (file descriptor 2) to the same place that standard output (file descriptor 1) is going, namely the log.txt file. — Jonathan Leffler
– Jonathan Leffler, Commented May 2, 2015 at 2:46

StephaneM · Accepted Answer · 2015-04-15 12:37:16Z

1

Try this:

sqlplus -s ${USER}/${PWD}@${DATABASE}
spool your_file_name.log
@@${LOADDIR}/VV_validation.sql
spool off

answered Apr 15, 2015 at 12:37

StephaneM

4,8791 gold badge19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Naveen Over a year ago

this is working, but spool is overwriting my log file, which was written already by previous statements.... is there anyway i can append ?

Naveen Over a year ago

I tried with APPEND like this 'sqlplus -s ${USER}/${PWD}@${DATABASE} spool your_file_name.log APPEND @@${LOADDIR}/VV_validation.sql spool off' and it worked... thanks @StephaneM

Collectives™ on Stack Overflow

Logging .sql file output to log file in shell script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related