Blame | Last modification | View Log | Download | RSS feed
CREATE OR REPLACE Function WS_FILTRI_INSERT
(
sDESCRIZIONE IN VARCHAR2,
sVALORE IN VARCHAR2,
sFLG_TIPO IN VARCHAR2)
RETURN NUMBER IS
TEMP_KEY NUMBER;
-- Declare program variables as shown above
BEGIN
-- TEMP_KEY:=WS_GRUPPI_FUNZIONE_SEQ.nextval;
select WS_FILTRI_SEQ.NEXTVAL into TEMP_KEY from dual;
INSERT INTO WS_FILTRI
( COD_FILTRO, DESCRIZIONE, VALORE, FLG_TIPO)
VALUES
( TEMP_KEY,sDESCRIZIONE,sVALORE, sFLG_TIPO );
RETURN TEMP_KEY ;
-- EXCEPTION
-- WHEN exception_name THEN
-- statements ;
END;
/