Advertisement
Guest User

Untitled

a guest
Jul 25th, 2014
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. create or replace
  2. TRIGGER test_trig
  3. AFTER CREATE
  4. ON SCHEMA
  5.  
  6. DECLARE
  7. --oper ddl_log.operation%TYPE;
  8. v_object_type varchar2(100);
  9. BEGIN
  10.  
  11. SELECT ora_dict_obj_type
  12. into v_object_type
  13. FROM DUAL;
  14. If upper(v_object_type)='TABLE' then
  15. SEC_ADMIN.my_package.my_proc();
  16. end if;
  17. END test_trig;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement