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;

/