Re: SQL Function call does not fail on no_data_found ?
Date: Tue, 23 Mar 2010 23:16:54 +0100
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
> 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)
Maxim Received on Tue Mar 23 2010 - 17:16:54 CDT