Re: Newbie: Why does this tiny function declaration fails?

From: Johan Wegener <xjw_at_xdde.xdk>
Date: Tue, 13 Jul 1999 13:10:43 +0200
Message-ID: <7mf6ot$nki$1@news101.telia.com>

Ralf Boroschewski <ralf_at_transmedia.de> skrev i en nyhedsmeddelelse:378B2745.F79DA3C7_at_transmedia.de... [snip]
> FUNCTION banana (tomato IN NUMBER)
> RETURN NUMBER
> IS
> potato NUMBER;
> BEGIN
> potato:=tomato+1;
> RETURN potato;
> END banana;
>
>
> The german reply said, that potato is not declared. I'm working as user
> 'internal' as SYSDBA.

Some ideas:

Try prepending the "Create" keyword to your definition. This compiles fine in my 8.0.4/NT.
Try not working as internal. Use system/manager in stead. Consider changing to "potato NUMBER := 0;" to make your example semantically correct.

Tschüss,
Johan Received on Tue Jul 13 1999 - 06:10:43 CDT