Quote:
Originally Posted by
guddu_12
I have an issue since this database part is done in the middle of the scripts and it exit finally from the scripts, how can i make sure it does it part in data base and then execute rest of the scripts
hmm, you already know the routine: post an error message and we take a look at it. If there is no error message, start the script with "ksh -x <scriptname>" and show the relevant parts of the output (before you ask why redirection doesn't work: it goes to <stderr>).
In other words: D-E-B-U-G the script by S-E-A-R-C-H-I-N-G for the error instead of sitting there and asking us things we cannot answer (because we do not see what is on your monitor or harddisk).
My guess is that one of the "exit" statements meant for for exiting "sqlplus" is in fact directed at the shell, which would make the shell (and the script) exit. This is only an unproven suspicion, though.
I hope this helps.
bakunin