Create a session parameter [message #9953] |
Tue, 16 December 2003 23:17 |
Ben
Messages: 48 Registered: January 2000
|
Member |
|
|
Hi,
what is the easiest way to create a session parameter and put a value in it?
greetings,
Ben
|
|
|
Re: Create a session parameter [message #9954 is a reply to message #9953] |
Wed, 17 December 2003 00:57 |
Frank Naude
Messages: 4579 Registered: April 1998
|
Senior Member |
|
|
Hi Ben,
You may want to consider using a "session-level" temporary table. Look at this example:
CREATE GLOBAL TEMPORARY TABLE session_variables
(var varchar2(30), val VARCHAR2(30))
ON COMMIT PRESERVE ROWS
/
Rows in this table will only be visible to the session that inserted the data. Oracle will automatically delete a session's rows after it disconnected.
Best regards.
Frank
|
|
|
Re: Create a session parameter [message #9955 is a reply to message #9954] |
Wed, 17 December 2003 04:22 |
Ben
Messages: 48 Registered: January 2000
|
Member |
|
|
Hi Frank,
i see what you mean buth i should find this parameter in a JSP Application that we've implemented in a Oracle Portal tab page. Using the jsp tag <jsp:useBean id="parametername" context="session" class="java.lang.String"/>
By using <%=parametername%>, I should be able to get the value of the parameter they told me buth the only thing I get is NULL.
It's Driving me Nuts...
|
|
|