Shell Programming and Scripting

which sqlplus

Originally Posted by shary

Hi Guys,

I am trying to tun a oracle proedure throgh unix shell script but it is not running i dont know why ? i have tested this procedure in sqlplus and it was working fine.
can you see the script and sql file and let me know where is my mistake.

script:bm_chart_table_loading.sh

#!/usr/bin/sh
sqlplus -s redknee/chrome9 @myproc.sql ( This line will run the commands in file 'myproc.sql' after connecting to oracle as redknee)
exit 0; ( This line will cause an exit from the script, below lines won't be executed )
ipcg1:/opt/redknee/home/oracle/Procedures_Execution[!]>cat myproc.sql
begin
proc_insert_bmchart1;
end;
/
exit 0;

sql file:myproc.sql

begin
proc_insert_bmchart1;
end;
/