Here there is the procedure:

CREATE OR REPLACE PROCEDURE <user>.LOG(I_TEXT IN VARCHAR2, I_TYPE IN VARCHAR2) IS
  v_id NUMBER;
BEGIN
  select SEQ_WH_SQL_LOG.nextval into v_id from dual;

  insert into WH_SQL_LOG
    (ID_LOG, DATA_LOG, TEXT_LOG, TYPE_LOG)
    values
    (v_id, sysdate, I_TEXT, I_TYPE);

END LOG;