create function xcurr return varchar2 is
v_curr varchar2(32);
begin
SELECT SYS_CONTEXT ('USERENV','CURRENT_USER') into v_curr from dual;
return v_curr;
end;
只要PL / sql对象没有AUTHID CURRENT_USER,这就可以工作.
create function xcurr return varchar2 is
v_curr varchar2(32);
begin
SELECT SYS_CONTEXT ('USERENV','CURRENT_USER') into v_curr from dual;
return v_curr;
end;
只要PL / sql对象没有AUTHID CURRENT_USER,这就可以工作.
