Search Results

can i have any update on this post ? ..

Plz find the attached shell script and and log files.

You can see that procedure 2 for RGR_1 table has been failed but still the 3rd procedure ran which is not am not intended to execute.

SO...

Sincere apologies for the confusions, am relatively new to this forum and unix :(

Proc_*.sql will have pl/sql statements in it. I can able to handle the exception there.


I am doing in all...

Let me make it clear

It always returns ZERO for me
Actually i have executing a "sqlplus" command with the params as db username, pwd schema and the pl/sql file[which is having procedure] in -s...

Dear all,

How to make sqlplus command to exit with an apt error code in bash script,
It always returns 0 for me.

Thanks