How to print logs in unix prompt or to a log file?

view full story

http://www.unix.com – I am executing a stored procedure through shell script. In the procedure, i have dbms_output.put_line to log the comments. This is working fine and but logs are available only after the execution of the pl/sql procedure's completion. I want to print the log comments while executing the procedure itself. is there a way to do it? ---------- Post updated at 02:46 AM ---------- Previous update was at 02:03 AM ---------- Shell script Code: logs=$root"/logs" DATE=`date '+%Y%m%d'` exec >> $logs/subprod_${DATE}.log 2>&1 sqlplus -s $user/$pass@$tns @$sql/inv_proce.sql & (HowTos)