Re: help with exceptions please

On Sep 25, 7:48 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> And it's quite common to misuse the -20000 over and over, with
> different text.

Or use it, depending on how you look at it.

If you need to alert a calling procedure that, let's say, the number of bananas ordered is below the regulatory requirement for a Tuesday, the numeric error code is irrelevant unless you intend to assign unique codes to all such errors, which in my experience is a huge and very likely doomed undertaking that is unlikely to be worth the effort. What's certainly important is that the procedure fails with a meaningful message, i.e. the bit that goes:

'Order ' || v_order_id ||' contained ' || v_num_bananas || ' bananas: minimum order is ' || k_min_banana_order Received on Tue Sep 25 2007 - 16:36:04 CDT