Re: PL/SQL cookie

From: Daryl Collins <Daryl.Collins_at_usa.alcatel.com>
Date: Tue, 27 Jul 1999 09:07:05 -0500
Message-ID: <379DBD09.9B473C4@usa.alcatel.com>

declare variable like

  ck_names owa_cookie.vc_arr   -- this is a pl/sql table
  ck_values owa_cookie.vc_arr   -- this is a pl/sql table
  ck_count integer

this  call

  owa_cookie.get_all(ck_names,ck_values,ck_count);

sets up the pl/sql tables and the count
 
if ck_count != 0 then
   for i in 1..ck_count  loop
     htp.p('Cookie : '||ck_names(i)||' = '||ck_values(i));
   end loop;
end if;

This should put all the cookies on your page

cookie1 = value1
cookie2 = value2

Hope this helps

Daryl Collins

DooHee Kim~ wrote:

Hi,
I have a question as to how to use owa_cookie.get_all method.
I read the explanation and it 's supposed to return an array of cookie
names and values, but what exactly do I pass in and receive into?

I've set up the code as:
cookie owa_cookie.cookie;
cookie = owa_cookie.get_all (cookie.name, cookies.vals, cookie.val_nums);
Coudl somone explain how it 's properly done?
Thanks in advance.

Received on Tue Jul 27 1999 - 09:07:05 CDT