现创建了个triger,包含select osuser,
machine,
terminal,
program,
client_info
into str_osuser,
str_machine,
str_terminal,
str_program,
str_clientinfo
from v$session
where sid = (select distinct sid from v$mystat);
编译时报表或试图不存在v$mystat,但单独以本用户登陆时能成功执行select distinct sid from v$mystat语句阿,望那个高人指点。
|