Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

save login and password in cookie

851405Apr 20 2011 — edited Jun 21 2011
Hi everybody
i try to save login and password in cookie to register identifiers
i create two pl sql procedures to do that

Set Username Cookie :
 begin
owa_util.mime_header('text/html', FALSE);

owa_cookie.send(
    name=>'LOGIN_USERNAME_COOKIE',
    value=>:P101_PASSWORD||':'||lower(:P101_USERNAME));


exception when others then null;
end; 
Get Username Cookie
declare
    v varchar2(255) := null;
    c owa_cookie.cookie;
    a wwv_flow_global.vc_arr2;

begin

   c := owa_cookie.get('LOGIN_USERNAME_COOKIE');
   a := htmldb_util.string_to_table(c.vals(1));

:P101_USERNAME := a(2);
:P101_PASSWORD := a(1); 

:P101_TEST1 := a(1);
   
exception when others then null;
end; 
Now, i have problem with my password Item, because i cannot get the password saved in the cookie.
But when i create item TEST1 (type: Text field), i got the password saved in the cookie.
I think that the problem is the type of my password item, but i don't know how to resolve it

Thanks for help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2011
Added on Apr 20 2011
4 comments
542 views