Re: user defined exception.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Jan 2002 19:13:11 +0100
Message-ID: <ckj05ug3rh9akr5oj0sor4op2nsoctqtk3@4ax.com>

On 24 Jan 2002 09:48:54 -0800, ed.prochak_at_ALLTEL.COM (Ed prochak) wrote:

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

I'm considering logging a TAR with Oracle to change the default passwords in this FLA

Cheers

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 24 2002 - 12:13:11 CST