Trigger after create table

[htanga]

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 ...

[prakashs43]

object_name = TRIG_TEST
object_type = TRIGGER

FROM USER_OBJECTS
IS THIS WHAT U ARE LOOKING FOR ?

[htanga]

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 ...