Hello Friends ,

I have a shell script that connects to database and calls a stored procedure..

when I run the script I am getting the following

error ..

aggregation_shell_script.sh: sqlplus: not found

Please let me know what's wrong.

I don't find oraenv in either /var/opt/oracle or $ORACLE_HOME/bin



#!/bin/ksh
echo ""
echo "********************************************"
echo "*********** START OF THE PROCESS ********"
echo "********************"
echo ""
echo "---------------------------------------------------------------------------"
sqlplus -s scott/tiger << EOFSQL
@proc_aggregation_upd_tbl.sql
spool off
exit;
EOFSQL
echo "**************************"
echo "**************** END OF THE PROCESS **************"
echo "***************"

Try this: