Re: Return value of whenever sqlerror

Thanks for all comments. It has helped me.

Regards
Leon

Radoulov, Dimitre wrote:
> Or rewrite it like this:
>
> myResult1=$(sqlplus -S <<EOF
> $uid/$passwd
> set serverout on feed off
> whenever sqlerror exit failure
> exec mms.test_unix_success;
> EOF) && printf "%s\n" "Success: $myResult1" || printf "%s\n" " Failure:
> $myResult1"
>
>
> Regards
> Dimitre
Received on Thu Oct 19 2006 - 02:32:59 CDT