By default, APEX will assign the cookie used for an application a standard name in the format ORA_WWV_APP_NNN, where NNN is the application ID. This cookie contains the reference of the authenticated session of the application.
The presence of this cookie in the browser, allows access to the apex application resources through a specific session ID.
My question is:
can you retrieve the value of the ORA_WWV_APP_NNN cookie from an Apex 5.1 page?
I tried with owa_cookie.get('ORA_WWV_APP_106')but it returns a no data found (106 is the ID of my application). In the browser's developer tools I see this cookie correctly.
Instead, for example, owa_cookie.get('LOGIN_USERNAME_COOKIE') correctly returns the value of the cookie that contains the username.
As a test I used the following code in a button submit process:
declare
v varchar2(255) := null;
c owa_cookie.cookie;
cookie_Name varchar2(255) := 'ORA_WWV_APP_106';
--cookie_Name varchar2(255) := 'LOGIN_USERNAME_COOKIE';
begin
c := owa_cookie.get(cookie_Name);
:P1_COOKIE := c.vals(1);
end;
With javascript I do not think can be recovered, being a HttpOnly type cookie.
Thank's
Stefano