Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: need help with simple Function
"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
![]() |
![]() |