Glotzfisch.de

CREATE OR REPLACE PROCEDURE write_log (
   error_id IN NUMBER
   ,msg     IN VARCHAR2
)
IS
PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
  insert into zzz_errors (timestamp, error_code, message) VALUES (SYSDATE,error_id,msg);
  commit;
END write_log;

This entry was posted on Wednesday, 19. March 2008 at 15:21 and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback (Guckstu hier) from your own site.