Re: Aggregate PL/SQL function

Try this:

CREATE OR REPLACE FUNCTION SUMA_CANTSALIDAS RETURN NUMBER IS vTotal NUMBER;
BEGIN
   vTotal := 0;

   SELECT NVL(SUM(CantSalidas),0)
   INTO vTotal
   FROM ITEMS_ALMACEN;    RETURN vTotal;
END; Bye.
Eliseo
eliseohg_at_cantv.net

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful