Use stored procedure to log message : Utility Procedure « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Utility Procedure

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>

 

Related examples in the same category