REPOST: Re: user defined exception.

"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!!!

• WAS CANCELLED BY =======: From: ed.prochak_at_ALLTEL.COM (Ed prochak) Control: cancel <2b4a2940.0201240948.768077c0_at_posting.google.com> Subject: cmsg cancel <2b4a2940.0201240948.768077c0_at_posting.google.com> Date: Mon, 28 Jan 2002 01:07:17 GMT Message-ID: <cancel.2b4a2940.0201240948.768077c0_at_posting.google.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!telocity-west!DirecTV-DSL!gestalt.direcpc.com!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40716527

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 11:48:54 CST