Subversion Repositories Sigmater

CREATE OR REPLACE Function WS_ISTANZE_APPL_INSERT
  (
    sAPPLICAZIONE_ID            IN NUMBER,
    sISTANZA_APPL               IN VARCHAR2,
    sURL_APPL                   IN VARCHAR2,
    sURL_WS                     IN VARCHAR2
  )
  RETURN  NUMBER IS
--
-- To modify this template, edit file FUNC.TXT in TEMPLATE
-- directory of SQL Navigator
--
-- Purpose: Briefly explain the functionality of the function
--
-- MODIFICATION HISTORY
-- Person      Date    Comments
-- ---------   ------  -------------------------------------------
   TEMP_KEY                 NUMBER;
   -- Declare program variables as shown above
BEGIN
    select WS_ISTANZE_APPL_SEQ.NEXTVAL into TEMP_KEY from dual;

    INSERT INTO WS_ISTANZE_APPL
        ( ISTANZA_APPL_ID, APPLICAZIONE_ID , ISTANZA_APPL, URL_APPL, URL_WS)
    VALUES
        ( TEMP_KEY, sAPPLICAZIONE_ID , sISTANZA_APPL, sURL_APPL,sURL_WS);
    RETURN TEMP_KEY ;
--EXCEPTION
--   WHEN exception_name THEN
--       statements ;
END;
/