How to execute all query in one session

[tihlex]

Hi everyone. I have a problem.

1. I select 2 parameters on selection app (DT and ID)
2. In on-demand app I call a procedure (ORACLE) with these parameters like this:
   1. Set call proc_name(DT) !EXECUTE _NON_SELECT_QUERY;
   2. Set call proc_name(ID) !EXECUTE _NON_SELECT_QUERY;
3. The view is created with data based on these parameters
4. I select data from view.

In dev it is work very well.

But in production we have a problem: every query execute in new session. And when we select data from view, view is empty.

My question: how to execute all query in one session? Mybe some setting in qlik (qmc)?

[Mario_Petre]

Are you using the native Oracle connector? Also, have you verified your connection details for any differences between Single Node and Production? 

[tihlex]

We use standart oracle conector in Qlik Sense. Connection details is same, credentional difference only .

[tihlex]

Who did encounter these problem?

[tihlex · Accepted solution]

We updated our qlik sense stand and problem fixed.