Re: USERS

>>>>> "DA" == DA Morgan <damorgan_at_exesolutions.com> writes:

 DA> s Lehaire wrote:
>> Hi, I want to know in a procedure who is executing it .
>>
>> may anyone have the solution ?
>>
>> Thx for help

 DA> Inside the procedure:

 DA> INSERT INTO log_table VALUES (user_id_information_stuff); COMMIT;

 DA> Unless you plan on active monitoring.

Might not that commit cause unexpected/unwanted side effects?

I would create a log_user function which inserts data into a log table and define it as an autonomous transaction. You could then call that procedure from within the original procedure and know it won't have any impact on the main transaction logic.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!