SP to INSERT row to TABLE

CREATE OR REPLACE PROCEDURE C_EVENT(
    IN p_FILEID_FK BIGINT,
     IN p_KEYVALUE VARCHAR(100),
     IN p_PROCESSED CHAR(1))
LANGUAGE SQL
MODIFIES SQL DATA
DYNAMIC RESULT SETS 1
SET OPTION DATFMT=*ISO

P1: BEGIN
    DECLARE num_records INTEGER DEFAULT 0;
    DECLARE SQLCODE INTEGER DEFAULT 0;

    -- Return auto-values to caller
    DECLARE @prvSqlCode SMALLINT ;
    DECLARE CursorNotOpen CONDITION FOR '24501' ;

    DECLARE cursor1 CURSOR WITH RETURN FOR
    SELECT 'EVENTID, CREATED, LASTUPDATED' AS rlist, EVENTID,
             FILEID_FK,
             KEYVALUE,
             PROCESSED,
             CREATED,
             LASTUPDATED
    FROM FINAL TABLE (
    INSERT INTO BEN_EVENT (FILEID_FK,
             KEYVALUE,
             PROCESSED)
    VALUES(p_FILEID_FK,
             p_KEYVALUE,
             p_PROCESSED));

    DECLARE CONTINUE HANDLER FOR CursorNotOpen
        SET @prvSqlCode = SQLCODE ;

    CLOSE cursor1;
    OPEN cursor1;

    IF SQLCODE < 0 THEN
        SET num_records = SQLCODE;
    ELSE
        GET DIAGNOSTICS num_records = ROW_COUNT;
    END IF;
    RETURN num_records;
END P1;