SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

calling pl/sql stored procedure from shell script ( kshell)

454116Sep 14 2005 — edited Sep 14 2005

hello.,

i have written a stored procedure. i need to call this stored procedure from a unix shell script ( korn shell).
can anyone please help me how can i do it.actually there are 3 stored procedures. so my shell script has to call each stored procedure, execute it then go to next stored procedure execute it.
if by chance inbetween any stored procedure do not execute then the shell script has to tell me that this stored procedure failed to execute.

please help me in this.

thanks
madan

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2005

Added on Sep 14 2005

3 comments

1,649 views