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 -> Newbie: Why does this tiny function declaration fails?

Newbie: Why does this tiny function declaration fails?

From: Ralf Boroschewski <ralf_at_transmedia.de>
Date: Tue, 13 Jul 1999 12:47:17 +0100
Message-ID: <378B2745.F79DA3C7@transmedia.de>


Hi,
after writing my first script in PL/SQL, I tried to declare a function which failed. I tried the "new_add_month" example from the book "Oracle PL/SQL" which faild. After that I wrote this tiny program to reduce complexity:

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.

Now the great question: Why does this declaration fails???

  Thanks for your help

                  Ralf

Received on Tue Jul 13 1999 - 06:47:17 CDT

Original text of this message

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