Hi all !
I would like to create a trigger on schema like the following :
create trigger trig_test after create on test.schema
begin
...
end;
/
How could I get the name and the type of the object which was created ?
Thanks a lot in advance ...
Printable View
Hi all !
I would like to create a trigger on schema like the following :
create trigger trig_test after create on test.schema
begin
...
end;
/
How could I get the name and the type of the object which was created ?
Thanks a lot in advance ...
object_name = TRIG_TEST
object_type = TRIGGER
FROM USER_OBJECTS
IS THIS WHAT U ARE LOOKING FOR ?
Unfortunatly no ...
I finally found what I was looking for :
ora_dict_obj_name and ora_dict_obj_type, which are event attribute functions.
It not really was easy to found out this in the Oracle Documentation :
Oracle8i Application Developer's Guide - Fundamentals
Chapter 13 : Working With System Events
If this could help someone ...