Hi!

We develop a smartform application in K2 blackpearl with Oracle DB connection. In the oracle we created an audit tables where the oracle triggers write some informations, what client AD user is made an update or insert.

Few years ago, we wrote a .net application with Oracle, and we use an Oracle Context to strore the AD user, and the triggers are read this information from there. We try this method this project, but the K2 uses same sessions in the Oracle from every clients, so it not works correctly.

"A" user running the application in browser. The application call an oracle store procedure with AD user paramer, which is stored it in the oracle context. When the "B" user is running this application an another client machine, he call the store procedure with his AD user name. At this moment he is overwrite the context.

I think the problem is the K2 Oracle service instance is use the same session. Is there any configuration parameter to change this or do you have any idea

Thx

Laszlo