Re: SQL Function call does not fail on no_data_found ?
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 23 Mar 2010 23:16:54 +0100
Message-ID: <4BA93DD6.4080706_at_gmail.com>
On 23.03.2010 22:11, Mladen Gogala wrote:
> On Tue, 23 Mar 2010 18:16:23 +0100, Michel Cadot wrote:
>
>
>> Yes, no_data_found is trapped by SQL engine and converted to a NULL
>> value.
>
> Why is that? It looks like a huge bug to me. Is that documented anywhere?
>
>
>
Date: Tue, 23 Mar 2010 23:16:54 +0100
Message-ID: <4BA93DD6.4080706_at_gmail.com>
On 23.03.2010 22:11, Mladen Gogala wrote:
> On Tue, 23 Mar 2010 18:16:23 +0100, Michel Cadot wrote:
>
>
>> Yes, no_data_found is trapped by SQL engine and converted to a NULL
>> value.
>
> Why is that? It looks like a huge bug to me. Is that documented anywhere?
>
>
>
Afair, what Michel stated, was always expected behaviour. There is a couple of references on MOS on this subject (is kinda of personal preferences whether it can be considered as oficially documented, however, i'm not sure, maybe it found already its way into Oracle manuals)
Note 226211.1
Note 258653.1
Bug 893670
Bug 299941
Best regards
Maxim Received on Tue Mar 23 2010 - 17:16:54 CDT