create table t1(A number)
/

CREATE OR REPLACE PACKAGE pkg_fga_audit IS
  PROCEDURE fga_audit (sname VARCHAR2, 
                       tname VARCHAR2, 
                       pname VARCHAR2);
END pkg_fga_audit;
/

CREATE OR REPLACE PACKAGE BODY pkg_fga_audit IS
  PROCEDURE fga_audit (sname VARCHAR2, 
                       tname VARCHAR2, 
                       pname VARCHAR2) IS
    PRAGMA AUTONOMOUS_TRANSACTION;
  BEGIN
    INSERT INTO fga_log(txt)
    VALUES (' sname=' || sname || ' tname=' || tname || ' pname='|| pname);
    COMMIT;
  END fga_audit;
END pkg_fga_audit;
/

BEGIN
  dbms_fga.add_policy(
            object_schema => 'GOPAL',
            object_name => 'TEST_FGA',
            policy_name => 'TEST_FGA_ACCESS',
            audit_column => null,
            audit_condition => null,
            statement_types=> 'INSERT, DELETE, UPDATE',
            handler_module  =>'pkg_fga_audit.fga_audit');
end;
/