Re: USERS

Tim X wrote:

> >>>>> "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!

The commit will not cause a problem no matter what you are doing if you use PRAGMA AUTONOMOUS_TRANSACTION. Daniel Morgan Received on Sat Feb 01 2003 - 00:54:17 CST