LinuxQuestions.org - [SOLVED] Error with Unix script

Hi,

I have exported all the oracle env variables and it worked for today's run,Thanks a lot. i'll check another run as well.
modified code:

Code:

#!/usr/bin/ksh

#--------------------------------------------------------------------------------------------------------------#

export PATH=$PATH:/usr/oracle/client_11g/product/11.2.0/client11g/bin

ORACLE_PATH=/usr/oracle/client_11g/product/11.2.0/client11g/bin ; export ORACLE_PATH

ORACLE_SID=BARP2 ; export ORACLE_SID

ORACLE_HOME=/usr/oracle/client_11g/product/11.2.0/client11g ; export ORACLE_HOME

#qz='sqlplus barcqz/xdr56yhn@BARP2'

#wdc='sqlplus barcwdc/xdr56yhn@BARP2'

#--------------------------------------------------------------------------------------------------------------#

sqlplus barcqz/xdr56yhn@BARP2 <<EOF

update qz_dates set QZ_DT = sysdate;

update qz_dates_back set QZ_DT = sysdate;

update wdc_dates set WDCDATE = sysdate;

update WDC_PAY_EXRATE set WPESENTDATE = to_char(sysdate,'DD-MON-YY:HH:MI:SS') ;

update WDC_OU_STARTTIME set WOSBUSINESSDATE =sysdate;

commit;

exit

EOF



sqlplus barcwdc/xdr56yhn@BARP2 <<EOF

update WDC_PAY_EXRATE set WPESENTDATE=(substr(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),1,10)||'T'||substr(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),12,19));

commit;

exit

EOF

Thanks a lot :-)