Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 8.1.7 Bug ?

Re: 8.1.7 Bug ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 4 Nov 2001 14:01:29 +0100
Message-ID: <tuaerkp8aj23ab@corp.supernews.com>

"Damien Salvador" <damien.salvador_at_via.ecp.fr> wrote in message news:slrn9uae6a.bh8.damien.salvador_at_zen.via.ecp.fr...
> On 2 Nov 2001 23:48:39 GMT, Damien Salvador
> <damien.salvador_at_via.ecp.fr> a écrit:
> >>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.
>
>
> and we did quite a number of "side-tests". Checking the length of the
> variable instead of "is not null", or using nvl does no good.
>
> Did not try the 'decode' in our sql statement calling the function. I will
> try tomorrow :-)
>
> But still, it's only avoiding the issue.
>
> Oh, and I did not see the message from Sybrand directly. Only the answer,
> and he doesn't seem to be in my kill-file :-(
> Cancelled post or definitively me ?
> --
> Damien
>

Definitely you.
I don't think *hiding* the part where *you* think there are no problems, is a very good idea. There maybe side-effects like an assignment to the variable you are using. Anyway, you are asking the groups judgment and assistance, so I think you need to provide the *complete* function. You would have need to do that when submitting a TAR, so I don't think there are reasons to withheld the function from the group.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sun Nov 04 2001 - 07:01:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US