Hi Friends,
I Want to comment one line of code from below code.
DBA_ORACLE_USER=`DB.sh -u -a User`
DBA_ORACLE_PWORD=`DB.sh -p -a User`
sqlplus /nolog <<-END > ${logfile} 2>&1
WHENEVER OSERROR EXIT 9
WHENEVER SQLERROR EXIT SQL.SQLCODE
connect ${DBA_ORACLE_USER}/${DBA_ORACLE_PWORD}@${ORACLE_SID}
@${GITD_RootDir}/ABC/abc.sql
exit;
END
==================
I have commented as shown below.
DBA_ORACLE_USER=`DB.sh -u -a User`
DBA_ORACLE_PWORD=`DB.sh -p -a User`
#Commented start By Sri
#sqlplus /nolog <<-END > ${logfile} 2>&1
#Comment end by Sri
sqlplus /nolog <<-END >> ${logfile} 2>&1
WHENEVER OSERROR EXIT 9
WHENEVER SQLERROR EXIT SQL.SQLCODE
connect ${DBA_ORACLE_USER}/${DBA_ORACLE_PWORD}@${ORACLE_SID}
@${GITD_RootDir}/ABC/abc.sql
exit;
END
Script is working fine. But it's logging below error in log file.
SP2-0734 : unknown command begning " Added by...." rest of lines ignored
.
I thought , this problem might be unix comments inside oracle code.
Pls suggest on this.
Thanks in advance.
please use code tags