Anyone has experience using OAS building Web applications ? PROBLEM: Web client session - retaining values during session life.

From: keso <keso_at_hep.tel.fer.hr>
Date: Tue, 12 Oct 1999 16:40:39 +0200
Message-ID: <7tvh0m$4vt$1@bagan.srce.hr>

Seems like nobody knows, but i'll still ask ...

What solution should i implement for session variables (Web browser session, not oracle session) - variables that retain their values during client session ?
(I don't want to use cookies)

I wrote simple test procedure:

CREATE OR REPLACE package test as
  nCount number;
  procedure session_test;
end;
/

CREATE OR REPLACE package body test as

procedure session_test is
begin
 htp.p('old value of counter: ' || TO_CHAR(nCount));  htp.para;
 nCount := NVL(nCount, 0) + 1;
 htp.p('increased counter value: ' || TO_CHAR(nCount)); end;

end;
/

Procedure 'session_test' should increase counter each time it is called by URL and write the old and new values.
But it yields always the SAME value!! :(, no matter how many times i call it again by REFRESH button on my browser!!!

Browser response:

old value of counter: <- nothing because of null value increased counter value: 1

---

I set 'Client Sessions' to 'Enabled' (one of Web parameters of my OAS PL/SQL application)
and 'Max session idle time' to 600 and restarted OAS, but it doesn't work. No trace nor voice of client sessions.

Am i doing something wrong?
How i should solve this?

please help,

Vedran Received on Tue Oct 12 1999 - 09:40:39 CDT