WHENEVER SQLERROR doesn't work?

Hi,

    At the begginig of sql script I have: WHENEVER SQLERROR EXIT SQL.SQLCODE
WHENEVER OSERROR EXIT later on the package body. In one of the function there is a bug (in my case PLS-00103).
Package si compiled with warnings. WHENEVER SQLERROR doesn't exist in this case. (but it works for wrong statements outside the plsql blocks)

How to force the Oracle plsql-compiler to exit when PLS-number error occures?
(I suppose that I should use WHENEVER PLSQLERROR command, but such doesn't exits).
Or how to check at the end of the script that there was something wrong and to return error code to shell.

        Tomasz Received on Thu Mar 22 2001 - 03:58:08 CST