Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace
- TRIGGER test_trig
- AFTER CREATE
- ON SCHEMA
- DECLARE
- --oper ddl_log.operation%TYPE;
- v_object_type varchar2(100);
- BEGIN
- SELECT ora_dict_obj_type
- into v_object_type
- FROM DUAL;
- If upper(v_object_type)='TABLE' then
- SEC_ADMIN.my_package.my_proc();
- end if;
- END test_trig;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement