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

Home -> Community -> Usenet -> c.d.o.misc -> Re: need help with simple Function

Re: need help with simple Function

From: Randy Harris <randy_at_SpamFree.com>
Date: Wed, 12 Jan 2005 14:03:21 GMT
Message-ID: <J6aFd.8426$Vj3.2683@newssvr17.news.prodigy.com>


"Frank Piron" <empty_at_zero.nil> wrote in message news:opskhbloj9m0et4w_at_news.online.de...
> Hi,
>
> Am Wed, 12 Jan 2005 07:17:41 GMT schrieb Randy Harris
<randy_at_SpamFree.com>:
>
> > CREATE OR REPLACE FUNCTION Session_Hash
> > (sessid IN NUMBER ) RETURN NUMBER
> > IS
> > dig_sum INTEGER;
>
> You have to initialize with 0: dig_sum INTEGER:=0;
> Otherwise dig_sum is NULL and every expression with dig_sum as
> a component will evaluate to NULL.
> --
> Frank Piron,
> defrankatkonaddot
> (leftrotate two)

That was the problem. Thank you. Received on Wed Jan 12 2005 - 08:03:21 CST

Original text of this message

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