shary
November 19, 2008, 2:54am
1
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;
/
push
November 19, 2008, 3:36am
2
chk ur sqlplus
check whether its istalled or not
you can use command
shary
November 19, 2008, 4:15am
3
Hi
It is fine and sql plus is also working fine.
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;
/
You can use 'sh -vx bm_chart_table_loading.sh' to debug ur script and find the flow