Current Position:Home > Maintaining persistent client state in Oracle 8.1.6

Maintaining persistent client state in Oracle 8.1.6

Update:11-30Source: network consolidation
Advertisement
I'm running Oracle 8.1.6 on Windows NT 4.0.
What are the methods to maintain the state of HTTP session (variable values, maybe transaction state) between the requests of the same user, in other words, how can I maintain HTTP session state in Oracle 8.1.6?
It's preferable to avoid using cookie, but I'll be very grateful for any advice.
Thanks in advance, Alex.

The Best Answer

Advertisement
Here's my Javascript Code for writing the Cookie (adapted from www.webmonkey.com):
Htp.p('<script language="JavaScript"><!--
function SetCookie(){
if(document.cookie=="")
{var t_ck="cotavalor=p_cliente:'&#0124; &#0124;to_char(t_new_CV_Cookie,'9999999999')&#0124; &#0124;'";var t_date=new Date("December 31, 2050");var t_ck_date=t_date.toGMTString();
t_ck=t_ck+";expires="+t_ck_date+";path=/";
document.cookie=the_cookie;}
else {return false;}}
//--></script>
<script language="JavaScript"><!--
SetCookie()
//--></script>');
Now here's my PL/SQL code for reading it:
t_cookie := owa_cookie.get('cotavalor');
Simple. I had to write that Javascript cause the Functions provided by Oracle didn't seem to work at all, while the Javascript version works easily.
null
  • Maintaining persistent client state in Oracle 8.1.6 Update:11-30

    I'm running Oracle 8.1.6 on Windows NT 4.0. What are the methods to maintain the state of HTTP session (variable values, maybe transaction state) between the requests of the same user, in other words, how can I maintain HTTP session state in Oracle 8

  • NLS_LANG setting for a client with multiple Oracle servers Update:11-30

    Hello! We have a web application which has to connect to one of the Oracle servers with different charactersets. When the NLS_LANG on the client is a single byte encoding and the server has a single byte encoding there are no problems. We have now a

  • Connecting an Oracle 8i client to an Oracle 9 DB Update:11-30

    Hey, my company just upgraded an Oracle8i instance to an Oracle9 installation. At first I was given link errors pertaining to an oci9 issue. I resolved that by patching my JDBC driver(classes12.zip). Now I am told: java.lang.UnsatisfiedLinkError: get

  • Oracle Calendar desktop client connect to oracle database Update:11-30

    Hi Expert, my end user want to Oracle Calendar desktop client connect to our 10G databasae. there are no TNS file in Oracle Calendar desktop client. How to configure Oracle Calendar desktop client to connect oracle database? Thanks JImWhat are the co

  • Connect Oracle 10g client to the Oracle 10g database behind a firewall Update:11-30

    I need to connect an Oracle 10g client to the Oracle 10g database (windows server 2003 box) behind a firewall. I ran into this problem: Port redirection. Port redirection requires the Oracle client to connect to the database using a different port (u

  • How to install Multi-Client Installation of Oracle Developer Update:11-30

    Could someone help me figure out the documentation on how to do a multi-client installation of Oracle Developer. I'm reading the section 1.3 in the Getting Started manual for Oracle Developer on NT. In trying to configure the OCSM host machine there

  • Install and maintain two lattest versions of oracle discover ,owb , htmldb Update:11-30

    To install and maintain two lattest versions of oracle discover ,owb and htmldb in one server , what are requirements. what steps to follow to install and maintain. My Current setup is Oracle Discoverer Suite 10g (9.0.4.0.1) , HTML_DB Release 2.0 OWB

  • Client files for Oracle 8.1.6 Update:11-30

    Hi folks ... Where can I download the client files for Oracle 8.1.6 ... We are running Oracle on a sun box and my development environment runs on nt and am using WebLogic Server 6.0 ... Thanks for the help!If you go to "Software", you can downlo

  • PAPI client in J2EE (Oracle app server, OC4J) Update:11-30

    Hello, We have a problem with using RMI-based PAPI in our J2EE application. Our client code runs fine as a standalone program, but doesn't work when it's used as a part of a J2EE application deployed to OC4J. There seems to some incompatibility betwe

  • Difference between instant client and full oracle client Update:11-30

    Everyone, I had read the below lines from a goldengate pdf. Someone please explain me what is the difference between instant client and full oracle client? What is the use of XDK libraries.? " The full Oracle client must be used with GoldenGate so th