Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Toolkit - deleting cookies?
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.
-- jeremyReceived on Mon Mar 13 2006 - 11:08:16 CST