Sample Header Ad - 728x90

Oracle schema object name when fire trigger

0 votes
1 answer
629 views
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