Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How I can Know Terminal name

user8942603Feb 25 2010 — edited Feb 25 2010
Dear All

I have Trigger And I need Insert Terminal Name (Client) of Who Insert or update or delete on table.

How i can use it.

select terminal
into v_terminal_name
from v$session
where audsid = userenv('SESSIONID');

when use this pl/sql in the Trigger the error occured of v$session

PL/SQL: ORA-00942: table or view does not exist


Thanks In Advance
This post has been answered by NTR on Feb 25 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2010
Added on Feb 25 2010
8 comments
969 views