DECODE Function
This function decodes a raw token value.
Syntax
function decode (
p_value in varchar2,
p_signature_key in raw default null )
return t_token;
Parameters
Table 21-3 DECODE Function Parameters
Parameter | Description |
---|---|
|
A raw token value contains 3 base64-encoded parts, which are separated by |
|
If not null, validate |
Returns
A t_token
.
Raises
VALUE_ERROR
: The input value is invalid.
WWV_FLOW_CRYPTO.UNSUPPORTED_FUNCTION
: The token is signed using an unsupported function.
Example
This example decodes an encoded token and print it's contents.
declare
l_token apex_jwt.t_token;
l_keys apex_t_varchar2;
begin
l_token := apex_jwt.decode (
p_value => 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJsb2dnZWRJbkFzIjoiYWRtaW4iLCJpYXQiOjE0MjI3Nzk2Mzh9.gzSraSYS8EXBxLN_oWnFSRgCzcmJmMjLiuyu5CSpyHI' );
sys.dbms_output.put_line('--- Header ---');
apex_json.parse(l_token.header);
l_keys := apex_json.get_members('.');
for i in 1 .. l_keys.count loop
sys.dbms_output.put_line(l_keys(i)||'='||apex_json.get_varchar2(l_keys(i));
end loop;
sys.dbms_output.put_line('--- Payload ---');
apex_json.parse(l_token.payload);
l_keys := apex_json.get_members('.');
for i in 1 .. l_keys.count loop
sys.dbms_output.put_line(l_keys(i)||'='||apex_json.get_varchar2(l_keys(i));
end loop;
end;
Output:
--- Header ---
alg=HS256
typ=JWT
--- Payload ---
loggedInAs=admin
iat=1422779638
Parent topic: APEX_JWT