1

Procedure to be executed from shell scripts

view story
linux-howto

http://www.unix.com – Hi, I am looking for a script wherein i will be able to execute below procedures one by one in line and next procedures starts only when the previous one completes and also after execution of each procedure i will be getting a automted mail as "PL/SQL PROCEDURE SUCCESSFULLY EXCETUTED". Quote: exec dbms_stats.gather_table_stats(' ',' '); exec dbms_stats.gather_table_stats(' ',' '); exec dbms_stats.gather_table_stats(' ',' '); exec dbms_stats.gather_table_stats(' ',' '); exec dbms_stats.gather_table_stats(' ',' '); exec dbms_sta (HowTos)