I need to get the object name and user name from oracle schema after fire a trigger. It executes on DDL statements. I need to get executed user name and object name which trigger executed on. Below is my PL/SQL code.
CREATE OR REPLACE TRIGGER orders_changes
after drop or alter or create on schema
DECLARE
v_username varchar2(10);
obj_name varchar2(300);
BEGIN
-- Find username and object name
SELECT user, object_name INTO v_username, obj_name
FROM dual;
insert into table1 values (v_username, obj_name);
END;
Seems issue is with the way I access the object name. It gives an error. Please any one can help me to solve this.
Asked by Anuradha
(113 rep)
Dec 18, 2018, 08:08 AM
Last activity: Aug 28, 2020, 09:01 AM
Last activity: Aug 28, 2020, 09:01 AM