-
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 ?
siva prakash
DBA
-
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 ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|