Re: min(); never no_data_found
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 25 Dec 2009 19:51:18 -0800 (PST)
Message-ID: <e7670492-a2b1-40a0-8f5b-4c6eadeed45a_at_j42g2000yqd.googlegroups.com>
On Dec 23, 10:10 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <79bb2ee5-f28a-43b9-af1e-4597012495f0
> _at_a32g2000yqm.googlegroups.com>, Mark.Powe..._at_hp.com says...
>
>
>
> > Cate, why not test for a NULL value being returned and if so the RAISE
> > NO_DATA_FOUND?
>
> What's the opinion of this ng's contributors on the advisability of
> raising "standard" error conditions when the underlying reasons for
> raising that error are different?
>
> To me it seems like a practice not to be recommended - potential for
> misleading people unfamiliar with the code later on in maintenance mode.
>
> --
> jeremy
Date: Fri, 25 Dec 2009 19:51:18 -0800 (PST)
Message-ID: <e7670492-a2b1-40a0-8f5b-4c6eadeed45a_at_j42g2000yqd.googlegroups.com>
On Dec 23, 10:10 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <79bb2ee5-f28a-43b9-af1e-4597012495f0
> _at_a32g2000yqm.googlegroups.com>, Mark.Powe..._at_hp.com says...
>
>
>
> > Cate, why not test for a NULL value being returned and if so the RAISE
> > NO_DATA_FOUND?
>
> What's the opinion of this ng's contributors on the advisability of
> raising "standard" error conditions when the underlying reasons for
> raising that error are different?
>
> To me it seems like a practice not to be recommended - potential for
> misleading people unfamiliar with the code later on in maintenance mode.
>
> --
> jeremy
You have a point. I normally use the 20xxx error codes Oracle reserved by Oracle for customer application error codes but my post just adresses one way to do what the OP asked.
HTH -- Mark D Powell -- Received on Fri Dec 25 2009 - 21:51:18 CST