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: PL/SQL Toolkit - deleting cookies?

Re: PL/SQL Toolkit - deleting cookies?

From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 13 Mar 2006 17:08:16 -0000
Message-ID: <MPG.1e7fb75776bca33498a12d@news.individual.net>


In article <1142269268.599877.219740_at_j33g2000cwa.googlegroups.com>, hpuxrac says...
>
> Jeremy wrote:
> > Hi everyone... can any of you shed some light on why the following
> > doesn't remove the cookie?
> >
> > Here is the simple procedure:
> >
> > create or replace procedure lo
> > is
> > BEGIN
> > owa_util.mime_header('text/html', false);
> > owa_cookie.remove('ccp_user100292','102210:148256');
> > owa_util.http_header_close;
> > end lo;
> > /
> >
> > Then I run this from a browser but the cookie remains unaltered. My
> > browser is reporting the cookie as existing like this:
> >
> > Name ccp_user100292
> > Value 102210:148256
> > Host acer
> > Path /
> > Secure No
> > Expires At End Of Session
> >
> >
> > I am guessing it is something I am not doing that I should be... but
> > what?
>
> Is it possibly because you have setup a session based cookie that
> perhaps cannot be removed ( only goes away when browser session is
> ended )?
>

Well they are session-based cookies and the information I am showing concerning the existence of cookies is from the cookie manager within the browser (Firefox in this case) (as opposed to cookie files written to disk).

The owa_cookie.remove procedure actually I think sets an expiration which, presumably, causes the browser to ignore once set - for example if I remove the owa_util.mime_header and owa_util.http_header_close calls I see the following written to the browser:

Set-Cookie: ccp_user100292=102210:148256; expires=Monday, 01-Jan-1990 08:00:00 GMT; So I am thoroughly confused as to why this is not working.

-- 

jeremy
Received on Mon Mar 13 2006 - 11:08:16 CST

Original text of this message

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