"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C4D5E9C.17D42A7E_at_exesolutions.com>...
> This is remarkably easy:
>
> CREATE OR REPLACE PROCEDURE xyz IS
>
> x PLS_INTEGER;
> rtfm EXCEPTION;
>
> BEGIN
> SELECT COUNT(1)
> INTO x
> FROM dual;
>
> IF x > 1 THEN
> RAISE rtfm;
> END IF;
>
> EXCEPTION
> WHEN rtfm THEN
> DBMS_OUPUT.PUT_LINE('Another User Did Not RTFM');
> WHEN OTHER THEN
> DBMS_OUPUT.PUT_LINE('Something Else Happened');
>
> END;
> /
>
>
> Daniel Morgan
>
I love your choice of exception name!!!
Received on Thu Jan 24 2002 - 11:48:54 CST
