Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Debug Logs In The Database

05.30.2007
| 2863 views |
  • submit to reddit 
        How to log things in the database

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;
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers