Hi,
While executing Below trigger I am getting Below error message.
Error(10,11): PLS-00201: identifier 'DBA_FGA_AUDIT_TRAIL' must be declared
Error(10,11): PL/SQL: Item ignored
Error(11,10): PLS-00201: identifier 'DBA_FGA_AUDIT_TRAIL' must be declared
Error(11,10): PL/SQL: Item ignored
Below is my trigger creation sql.
Can anyone please let me know how to resolve this issue? As I am not good in pl/sql side.
CREATE OR REPLACE TRIGGER MAIL_TRIGGER
AFTER INSERT OR DELETE OR UPDATE
ON TEST_TABLE.xxxxxxxxx
FOR EACH ROW
BEGIN
declare
vsql_text dba_fga_audit_trail.sql_text%type;
vdb_user dba_fga_audit_trail.db_user%type;
vos_user dba_fga_audit_trail.os_user%type;
begin
select sql_text,db_user,os_user
into vsql_text,vdb_user,vos_user
from dba_fga_audit_trail where rownum < 2;
SEND_MAIL('xxxxxxx', 'xxxxxxxxxx', 'DML statement happens in xxxxxxx table', vsql_text);
end;
END;
/