something like:
...
select getvaluetx(..) as web_session_user from dual
...
select edition_name from custom_table where user_name = '<web_session_user>'
...
ALTER SESSION SET EDITION='<edition_name>' -- FYI: execute immediate is not valid!
...

asked 01 Sep '15, 06:41

bisov_r's gravatar image

bisov_r
111
accept rate: 0%


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:

FYI: execute immediate not valid

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,
Yalim

link

answered 01 Sep '15, 09:51

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×16

Asked: 01 Sep '15, 06:41

Seen: 795 times

Last updated: 01 Sep '15, 09:51


© Copyright Gerger 2017