User log-in and trigger

[nickty]

Hi
I have constructed a form(using WebDB) which will be used by 20+ users in 10+ offices.
Each has their own unique log-in.
There are fields on the form for "logged_by" and "office_code".
Is it possible (somehow) to capture the log-in and write a trigger that automatically inserts values into the required fields.
ie

if log-in = smith insert 'LONDON' into :new.office_code;


I am an oracle novice, so any help or advice is appreciated.
Thank you.

 

[karluk]

Try the suggestion in thread186-40445:

select user from dual;