Subversion Repositories Sigmater

CREATE OR REPLACE Function WS_ATTRIB_FUNZ_INSERT
(
    sNOME    IN VARCHAR2
)
RETURN          NUMBER IS
TEMP_KEY        NUMBER;
-- Declare program variables as shown above
BEGIN
-- TEMP_KEY:=WS_GRUPPI_FUNZIONE_SEQ.nextval;
    select WS_ATTRIB_FUNZ_SEQ.NEXTVAL into TEMP_KEY from dual;

    INSERT INTO WS_ATTRIBUTI_FUNZIONE
        ( COD_ATTRIBUTO, NOME)
    VALUES
        ( TEMP_KEY,sNOME);
    RETURN TEMP_KEY ;
-- EXCEPTION
--   WHEN exception_name THEN
--       statements ;
END;
/