Re: Stored Function Problem

From: Gunjeet Singh <gunjeet_at_sunsparkle.EBay.Sun.COM>
Date: 28 Jul 1998 23:46:02 GMT
Message-ID: <6plnrq$53t$1@ebaynews1.Ebay.Sun.COM>

Try

CREATE OR REPLACE FUNCTION radius.NewCallsFunc RETURN NUMBER IS

      rNumCalls NUMBER(10,0);
      lNewCalls NUMBER(10,0);
      lOldCalls NUMBER(10,0);
  BEGIN
      SELECT COUNT(*) INTO lOldCalls
      FROM radius.old_calls;

     SELECT COUNT(*) INTO lNewCalls
     FROM radius.new_calls;

rNumCalls := lOldCalls + lNewCalls;

RETURN(rNumCalls);
END;
/

The DECLARE keyword is not used in stored functions/procedures. It is however used in anonymous PL/SQL blocks.

Hope this helps ... Received on Tue Jul 28 1998 - 18:46:02 CDT