Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MOD_PLSQL and cookies - when available to the server?

Re: MOD_PLSQL and cookies - when available to the server?

From: Andy Hardy <junkmail_at_[127.0.0.1>
Date: Tue, 15 Nov 2005 07:57:15 +0000
Message-ID: <pr9tOfFbTZeDFAAh@[127.0.0.1]>


In message <-d2dnRGTb7Hd0-TeRVn-uQ_at_comcast.com> , Mark C. Stock <mcstockX_at_Xenquery.com> writes
>
>"Andy Hardy" <junkmail@[127.0.0.1]> wrote in message
>news:HsTWvQBi+PeDFAEH@[127.0.0.1]...
>> In message <dlaqst$vbc$1_at_news6.zwoll1.ov.home.nl> , Frank van Bortel
>> <frank.van.bortel_at_gmail.com> writes
>>>Andrew Hardy wrote:
>>>> Hi,
>>>>
>>>> I'm looking at a mod_plsql-based application which uses cookies to store
>>>> session identifiers that link to a table of session information.
>>>>
>>>> At the moment, the application sets the cookie during a user
>>>> (lightweight i.e. not a true database user) logon in the 'welcome'
>>>> screen.
>>>>
>>>> Various screens read the cookie to determine who they're talking to,
>>>> etc.
>>>>
>>>> I'd like to create a simple URL that allows a non-interactive access to
>>>> an existing procedure. Although I can create a simple procedure that can
>>>> check passed logon details and set the cookie, subsequent procedures do
>>>> not seem to be able to see the cookie.
>>>>
>>>> Is this because the cookie has not been sent back to the browser yet
>>>> (i.e. I haven't got the 'welcome' return to browser)? Or... am I doing
>>>> something wrong and cookies that have been created by the server should
>>>> be accessible even if the HTTP has not been returned to the client
>>>> browser? Or... something else!
>>>>
>>>> Environments to be supported are 8.1.7.4 and 10gR2.
>>
>> [snip]
>>
>>>Your clients browser handles cookies, so if you do not send
>>>a screen (HTML) *with* cookies, you can *never* request a
>>>cookie back on subsequent screens.
>>
>> OK, pretty much as I thought - I had hoped that Oracle might have the
>> cookie in some sort of a buffer prior to sending.
>>
>>>And -without knowing the application- I'd seriously look into
>>>global temporary tables (not an 8i feature, iirc)
>>>
>>
>> GTTs are in 8i, but I'm not sure how this would help me?
>>
>> Thanks for your reply,
>> --
>> Andy Hardy. PGP ID: 0xA62A4849
>
>
>presumably you're using OWA_COOKIE.SEND to set the cookie
>
>is OWA_COOKIE.GET not retrieving the value?

We are, but the current application does an HTTP 'send' on completion of the logon. This transfers the cookie to the client browser and makes it available to later 'gets'. I was hoping that the new URL/procedure would be able to 'send' the cookie and have it available for 'get' *before* I'd actually done the HTTP 'send' to the client.

>also, regarding GTTs, that would not be applicable for a web app, since GTTs
>are are session-specific and would not preserve the state from the
>browwer-session perspective, just from the database-connection perspective,
>and connections are shared by multiple browser-sessions.

Indeed, hence our use of a cookie and session table.

-- 
Andy Hardy. PGP ID: 0xA62A4849
Received on Tue Nov 15 2005 - 01:57:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US