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;