something like: |
Hi Bisov, If I understand you correctly, you want to be able to set the edition value for a logged in user's database session. Formspider 1.9 enables stateful database connections. So to make this work, you should probably use stateful connections. In theory, you could do this with stateless connections as well but you'd have to execute the ALTER statements for every request received by the server. What did you mean by:
Did you mean that Oracle does not allow us to alter the session and change the edition using an execute immediate command? I don't have an environment to try this easily and a quick google search didn't reveal much. if that is indeed the case, my next questions would be: "Can we execute the alter statement from the middle tier?" "If not, how do you recommend we execute this alter statement?" If running this alter statement is possible in execute immedaite, I see no problem doing this with Formspider. If this is not possible, we should enable you to execute this alter statement through Formspider middle tier and I think this is possible as well. Kind Regards, |