Session variable wanted

From: Pavel Vetesnik <Pavel.Vet_at_volny.cz>
Date: Wed, 5 Mar 2003 11:28:10 +0100
Message-ID: <b44jfr$kju$1@ns.felk.cvut.cz>

Hello,

I want to write an application using PL/SQL (with Oracle 8 installed), where user will access data using HTML interface.

What I am looking for is an variable, that will be kept during whole users session. I thought, that variables defined for whole package will do the task, but they probably do not.

I created a little testing application, which you may find at http://newalex.stk.cz:7777/pls/portal30/el_cas.testovaci.showpage1 . There are 2 procedures (1st page and 2nd page) and I want to keep is a variable set in the 1st page.

The source code follows. Any help is appreciated.

Thank you in advance,
Pavel

---

CREATE OR REPLACE PACKAGE testovaci IS

    cTitle VARCHAR2(100);

    PROCEDURE showpage1;
    PROCEDURE showpage2;
END;
/

CREATE OR REPLACE PACKAGE BODY testovaci IS

    PROCEDURE showpage1 IS
    BEGIN

        cTitle:='This is the text I want to keep...';
        htp.htmlopen;
        htp.bodyopen;
        htp.header(1, ctitle);
        htp.p('<a

HREF="http://newalex.stk.cz:7777/pls/portal30/el_cas.testovaci.showpage2">Cl ick for page2</a>');

        htp.bodyclose;
        htp.htmlclose;

    END;     PROCEDURE showpage2 IS
    BEGIN

        htp.htmlopen;
        htp.bodyopen;
        htp.header(1, cTitle);
        htp.p('If you can see "This is the text I want to keep..." above

this line, then everything works fine. If this is the only line on the page, then it doesn''t work.');

        htp.bodyclose;
        htp.htmlclose;

    END;
END testovaci;
/

GRANT EXECUTE ON testovaci TO PUBLIC;

---

Received on Wed Mar 05 2003 - 04:28:10 CST