select NVL(TERMINAL,'UNKNOWN) from V$SESSION where SID = 1;
you can have result from above snippet at sqlplus, but it shows error ORA-00942: table or view does not exist when you access from package body
View name : V_$SESSION
Public synonym known as : V$SESSION
Solution :
connect sys/[password]@[SID] as sysdba
GRANT SELECT ON V_$SESSION TO [username];
OR
GRANT SELECT ANY DICTIONARY TO [username];
0 comments:
Post a Comment