Mega Code Archive

 

Categories / Oracle PLSQL / Stored Procedure Function

 

Use stored procedure to log message

SQL> SQL> SQL> create table myLogTable(   2    username varchar2(30),   3    date_time timestamp,   4    message varchar2(4000) ); Table created. SQL> SQL> SQL> create or replace procedure log_message( p_message varchar2 ) as   2  pragma autonomous_transaction;   3    begin   4    insert into myLogTable( username, date_time, message )   5    values ( user, current_date, p_message );   6    commit;   7  end log_message;   8  / Procedure created. SQL> SQL> begin   2  log_message('hi');   3  end;   4  / PL/SQL procedure successfully completed. SQL> SQL> select * from myLogTable; USERNAME                       DATE_TIME ------------------------------ --------------------------------------------------------------------------- MESSAGE ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SYS                            11-JUN-08 08.44.26.000000 PM hi SQL> SQL> drop table myLogTable; Table dropped. SQL> SQL> SQL>