private static void writeRecords(Event[] events) {

        Event currentEvent = null;
        CallableStatement callStartCstmt = null;
        CallableStatement dialogCstmt = null;

        Connection connection = getConnection();
        try {
            callStartCstmt = connection.prepareCall("{call Insert_Call_Start_Event (?, ?, ?, ?)}");   
            dialogCstmt = connection.prepareCall("{call insert_dialog_event (?, ?, ?, ?, ?, ?, ?, ?)}");


            for (int i = 0; i < events.length; i++) {
                currentEvent = events[i];
                int jdbcReturnValue = 1;

                if (events[i] instanceof CallStartEvent) {

                    CallStartEvent callStartEvent = (CallStartEvent) events[i];
                    
                    callStartCstmt.setString(1, callStartEvent.getApplicationSessionId());
                    callStartCstmt.setString(2, callStartEvent.getAni());
                    callStartCstmt.setString(3, callStartEvent.getDnis());
                    callStartCstmt.setString(4, callStartEvent.getBrowserName());

                    jdbcReturnValue = callStartCstmt.executeUpdate();

                } else if (events[i] instanceof DialogEvent) {

                    DialogEvent dialogEvent = (DialogEvent) events[i];

                    dialogCstmt.setString(1, dialogEvent.getApplicationSessionId());
                    dialogCstmt.setTimestamp(2, new java.sql.Timestamp(dialogEvent.getDate().getTime()));
                    dialogCstmt.setString(3, dialogEvent.getContext());
                    dialogCstmt.setString(4, dialogEvent.getResult());
                    dialogCstmt.setInt(5, dialogEvent.getTurns());
                    dialogCstmt.setString(6, dialogEvent.getInputMode());
                    dialogCstmt.setString(7, dialogEvent.getInterpretation());
                    dialogCstmt.setInt(8, dialogEvent.getConfidence());
                    
                    jdbcReturnValue = dialogCstmt.executeUpdate();

                } 

                if (jdbcReturnValue != 1) {
                    logger.info(currentEvent.toString() + " - update returned unexpected value " + jdbcReturnValue);
                }else{
                	logger.info(currentEvent.toString());
                }
            }

            // commit updates for this run of the queue
            connection.commit();
            
        } catch (Exception e) {
            String message = "reporting database exception";
            if (currentEvent != null) {
                message += " while writing event: " + currentEvent.toString();
            }
            logger.warn(message, e);
            
        } finally {
            try {
                callStartCstmt.close();
                dialogCstmt.close();
                connection.close();
                
                logger.info("All Callable Statments and DB Connection closed.");
                
            } catch (SQLException e) {
                logger.error("Error encountered when trying to close resources.", e);
            }
        }

    }

CREATE OR REPLACE PROCEDURE Insert_Call_Start_Event (conn_id   IN VARCHAR2,
                                                    ani       IN VARCHAR2  DEFAULT NULL,
                                                    dnis      IN VARCHAR2  DEFAULT NULL,
                                                    host      IN VARCHAR2  DEFAULT NULL) AS

BEGIN

	INSERT INTO call (conn_id,
                         ani,
                         dnis,
						 host)
		  VALUES (conn_id,
                         ani,
                         dnis,
                         host);

END;
/

CREATE OR REPLACE PROCEDURE insert_dialog_event (conn_id        IN VARCHAR2,
                                                occurrence_time	IN TIMESTAMP,
                                                context        IN VARCHAR2,
                                                result         IN VARCHAR2,
                                                turns		IN NUMBER,
                                                input_mode     IN VARCHAR2  DEFAULT NULL,
                                                interpretation IN VARCHAR2  DEFAULT NULL,
                                                confidence IN NUMBER  DEFAULT NULL) AS

BEGIN

	INSERT INTO dialog_event (conn_id,
	                   	  event_id,
                          occurrence_time,
                          context,
                          result,
                          turns,
                          input_mode,
                          interpretation,
                          confidence)
		   VALUES (conn_id,
		         		  event_id_sequence.NEXTVAL,
                          occurrence_time,
                          context,
                          result,
                          turns,
                          input_mode,
                          interpretation,
                          confidence);

END;
/

if <something>
then <whetever>
else if <something else>
then <whatever else>