Re: Bug in WHENEVER in SQL*Plus 3.1.3.1.1 on VMS

In article <l.carl.pedersen-0808941341340001_at_kip-sn-97.dartmouth.edu> l.carl.pedersen_at_dartmouth.edu (L. Carl Pedersen) speaks about SQL*Plus 3.1.3.1:

> This version of SQL*Plus happily accepts the following syntax:
>
> whenever sqlerror exit rollback failure;
>
> However, this is not correct. In the correct syntax, the last two words
> are exchanged. The incorrect syntax results in an exit with a SUCCESS
> status.
>
> SQL*Plus should reject the incorrect syntax with an error message, but it
> doesn't. This may seem like a minor point, but the results of this bug
> *could* be fairly serious.

As of SQL*Plus 3.1.3.3, using incorrect EXIT command syntax will cause the EXIT usage message to be displayed. For backward compatibility SQL*Plus still commits & exits. The exit status is that of an EXIT FAILURE. Chris Received on Tue Aug 09 1994 - 01:28:45 CEST