Blame | Last modification | View Log | Download | RSS feed
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;
/