How to run package procedure using Crontab
Below is my crontab script to run . It is working fine in if I run it manually like
sh crontest
but if i call it in crontab , only echo is working , oracle commands are not working.
my crontab command is -> * * * * * sh /home/oracle/cron/crontest
*******************************************
crontest
*******************************************
#!/bin/sh
echo "Procedure start successfully : $(date) " >> /home/oracle/pro_test
sqlplus -s orpheus/frs@frs_ods<<END
set serveroutput on
exec pkg_orph_adhoc.pro_ca('3478409644','2011-07-01','2011-10-31');
insert into tt values(sysdate);
commit;
exit;
END
********************************************