Debug logs in the database
How to log things in the database
Create the table:
Write the things I need to the table:
Consult the things written:
Dont forget to drop it at the end:
Create the table:
create table TMP_LOG (HORA date, ENTRADA varchar(4000));
Write the things I need to the table:
INSERT INTO TMP_LOG (HORA, ENTRADA) VALUES(SYSDATE, 'V_NOM_DESTINATARIO1: '||V_NOM_DESTINATARIO1||', V_DOM_DESTINATARIO1: '||V_DOM_DESTINATARIO1|| ', P_NOM_DESTINATARIO_2: '||P_NOM_DESTINATARIO_2||', P_DOM_DESTINATARIO_2: '||P_DOM_DESTINATARIO_2|| ', B_DESTINATARIO: '||B_DESTINATARIO|| ', V_NOM_DESTINATARIO2: '||V_NOM_DESTINATARIO2||', V_DOM_DESTINATARIO2: '||V_DOM_DESTINATARIO2);
Consult the things written:
select * from tmp_log order by hora desc;
Dont forget to drop it at the end:
drop table TMP_LOG;
