how to alter schema in Oracle BI Administration

Question

hi,

I use the oracle BI administration tool and I want to change the schema I select data from. My idea was that the user will pass a parameter in url (I use the go url option) and according to that parameter I will know which schema I need to switch.

I created two initalization blocks.

1. select the name of the schema by the given parameter and set the name of the schema in the session variable called realityschema.

2. switch the schema by using the initalization string:

   alter session set current_schema = VALUEOF(NQ_SESSION.REALITYSCHEMA);

When I go to an answer in the presention sevices using a go url the log tell me the the first initalization block worked: it writeS "Returned 1 rows. query status: successful completion". But the second initaliztion block fails and writes "returned 0 rows. Query status: Failure"

Can someone tell me how can I fix this or is there another way I need to alter the schema? I don't want to set session variable for the user and password in the connection string.

thanks zeev