38.3 DECODE Function
This function decodes a raw token value.
Syntax
APEX_JWT.DECODE (
p_value IN VARCHAR2,
p_signature_key IN RAW DEFAULT NULL )
RETURN t_token;
Parameters
Parameter | Description |
---|---|
p_value |
A raw token value contains 3 base64-encoded parts, which are separated by '.' . The parts are header, payload and signature.
|
p_signature_key |
If not null, validate p_value 's signature using this key and the algorithm specified in header. The algorithms 'HS256' and 'none' are supported, but 'HS256' requires 12c or higher.
|
Returns
A t_token
.
Errors Raised
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