create or replace function my_get_name(v_objid number)
return varchar2 is
v_objname varchar2(100);
begin
select t.object_name into v_objname from dba_objects t where t.object_id=v_objid;
return v_objname;
end;
设置
3- 设置为参数为true
alter system set O7_DICTIONARY_ACCESSIBILITY =true scope=spfile;
重新登进去
查看结果