User Log-in and Trigger

[nickty]

Hi
I have constructed a form 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.

 

[SyedAqif]

Yes it is possible. Unfortunately I dont have developer installed so I can't write the actual code but I think this will surely help u

Search Help for "Current_User" and I think with the help of Get_Application_Property u'll be able to trap the name of current user. Store the name in a variable n use If condition to specify ur code. I hope this will help u.

Cheers!
Aqif