Oracle procedure is not executing in uix

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
exit 0;
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;
/

chk ur sqlplus

check whether its istalled or not

you can use command

Hi

It is fine and sql plus is also working fine.

You can use 'sh -vx bm_chart_table_loading.sh' to debug ur script and find the flow