Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
CREATE OR REPLACE Function WS_ATTRIB_FUNZ_INSERT
2 
(
3 
    sNOME    IN VARCHAR2
4 
)
5 
RETURN  	NUMBER IS
6 
TEMP_KEY        NUMBER;
7 
-- Declare program variables as shown above
8 
BEGIN
9 
-- TEMP_KEY:=WS_GRUPPI_FUNZIONE_SEQ.nextval;
10 
    select WS_ATTRIB_FUNZ_SEQ.NEXTVAL into TEMP_KEY from dual;
11 
 
12 
    INSERT INTO WS_ATTRIBUTI_FUNZIONE
13 
        ( COD_ATTRIBUTO, NOME)
14 
    VALUES
15 
        ( TEMP_KEY,sNOME);
16 
    RETURN TEMP_KEY ;
17 
-- EXCEPTION
18 
--   WHEN exception_name THEN
19 
--       statements ;
20 
END;
21 
/
22