1 Reply Latest reply: May 1, 2013 3:38 AM by Mkirtley-Oracle RSS

    Create Error Logs

    Xandot
      hello friends,
      I need your help!!!!!
      I want to create a function that will create automatically script for log trigger (Error Logs) .

      yet I am create one user for logs table (log_user) and another for triggers (owner_user) and connected via synonym.


      ---------------------------------------demo syntax-----------------------------------
      --------create function (table_name , owner_user , log_user)

      /* code for create trigger script */

      end;
      ---------------------------------------------------------------------------------------------

      Personal Oracle Database 10g Release 10.2.0.3.0