Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 8.1.7 Bug ?
On Fri, 02 Nov 2001 22:29:43 +0000, Connor McDonald
<connor_mcdonald_at_yahoo.com> a écrit:
>Sybrand Bakker wrote:
>> > -- Function, as written for 8.1.5 (does not work on 8.1.7)
>>
>> Is this the *complete* function?
>> If so, why can't you simply use the built-in decode?
>
>Probably because the decode will be a bucketload slower (if they are
>using this function not as a replacement for decode in sql)
This is indeed not the full function, but only the part that causes the failure. BTW, the exact pb seems to be in the 'if' statement.
We're doing quite a lot of subqueries in the PL/SQL block but it was just masking where the problem is :-/
-- DamienReceived on Fri Nov 02 2001 - 17:48:39 CST