declare
p_out varchar2(4000);
buffer varchar2(4000);
buffer := '{
"status":1,
"accessToken":"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImppYk5ia0ZTU2JteFBZck45Q0ZxUms0SzRndyIsImtpZCI6ImppYk5ia0ZTU2JteFBZck45Q0ZxUms0SzRndyJ9.eyJhdWQiOiJodHRwczovL2dyYXBoLndpbmRvd3MubmV0IiwiaXNzIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvZjBjYTc4NWUtZGY4MC00ODU5LWE0MDEtYjIxZmU1MGYxYzBkLyIsImlhdCI6MTYwMDc3NjU0MywibmJmIjoxNjAwNzc2NTQzLCJleHAiOjE2MDA3ODA0NDMsImFjciI6IjEiLCJhaW8iOiJFMkJnWUhCUDRQaW0rK2hyaGNUUEFvM3dBMkoxSE9YN0Rwc2RQL1JFL2J6ZEVRWFcwMU1CIiwiYW1yIjpbInB3ZCJdLCJhcHBpZCI6IjJkMzk3MmM5LTI5ZDMtNGM4MC05YTEyLTBhYTE0MWZiMTg0YyIsImFwcGlkYWNyIjoiMSIsImlwYWRkciI6IjUyLjE3Mi4yMDMuMjIwIiwibmFtZSI6IkUtSW52b2ljZSBLZWxsb2coS0lQTCkiLCJvaWQiOiI0YWIzOGVmMy1iYTMxLTQwOTktYmM3YS1iNjIwNjgyNDM1OTAiLCJwdWlkIjoiMTAwMzIwMDBEOURCRDc4NCIsInJoIjoiMC5BQUFBWG5qSzhJRGZXVWlrQWJJZjVROGNEY2x5T1MzVEtZQk1taElLb1VIN0dFeEpBSEkuIiwic2NwIjoiRGlyZWN0b3J5LkFjY2Vzc0FzVXNlci5BbGwgRGlyZWN0b3J5LlJlYWQuQWxsIERpcmVjdG9yeS5SZWFkV3JpdGUuQWxsIEdyb3VwLlJlYWQuQWxsIEdyb3VwLlJlYWRXcml0ZS5BbGwgTWVtYmVyLlJlYWQuSGlkZGVuIFVzZXIuUmVhZCBVc2VyLlJlYWQuQWxsIFVzZXIuUmVhZEJhc2ljLkFsbCIsInN1YiI6InF1SjluNWwzMXhzYWM5UUZoSVRwRE1WaVhBekxmX0hFTTk0WGRGMEM2Q2siLCJ0ZW5hbnRfcmVnaW9uX3Njb3BlIjoiQVMiLCJ0aWQiOiJmMGNhNzg1ZS1kZjgwLTQ4NTktYTQwMS1iMjFmZTUwZjFjMGQiLCJ1bmlxdWVfbmFtZSI6ImVpbnZvaWNldXNlckBraXBsLmV5YXNwLmluIiwidXBuIjoiZWludm9pY2V1c2VyQGtpcGwuZXlhc3AuaW4iLCJ1dGkiOiIwdnFpaDdNMWZFcUZGVFByeGh0N0FBIiwidmVyIjoiMS4wIn0.ikTLdCpPDfMZ1lRXfEDcdiB8id2AiFMT3isfDMaWLtJuQdDVpm4i9VOaHT2Iw4Eqg3XemvYdHgrjafvjmo66RpShe54G4PDDfiMcykCqGnS52gRJEVZQGmksuxdjVo__FOeT0YrzwZVKoy-VLFzWE32ILo-oDU1BafpiKAWA4bgesnleytDCyb7GSz5BZqN0QNj0W2CIyPr7UPfIBG02pa2giq6dCYcvkVEH20ThhPnLpH57FuauHftHPXx7arPQ8ULhsbxp5q9xvScwMgQrljHthkoNY8YfItCRCRGfqTvxe2RJYcd4BntrsoVHR0lFw9tx_nMwt0y3KdPd2hnBzA",
"refreshToken":"0.AAAAXnjK8IDfWUikAbIf5Q8cDclyOS3TKYBMmhIKoUH7GExJAHI.AgABAAAAAAAGV_bv21oQQ4ROqh0_1-tAAQDs_wIA9P89EwwVxEQomtrkDzBA5yoPgp73sSBBiBKMZ-HSBZfj_j1yy2dqRLX2-DoCSnN2cCB0yJnB_C7p8R35H_3xIm8us8yJ9YXEixr28PnoO9AanfWOqKE0Ypgi0H0sAhM1dYUUjNfUxRIXiDVZ_LKnUCnjVzwJU_BEveYIh9np2FUPofZhj6jnufmYPSknXsPJYT8uUR_-rVfAHh9kli1AogJPEQOIWyyhbtPHAlJ90TtkVwaD9pJLug3OqfpIGTL7wjJ6ZHJiaW1t2yijrlUFxk1mdlCdvMb-GMB39W894g-iw0Ku-4ALnkGEHHWHN2rD5yMsPnLznkQ4pj35biez-Yx6avWbHIAWU-m1dqk_PV2c5MBWYfY5lWZM_ME6ymCQNRjGHEdfgj2Tc4HG-g_lpP0auB7UZCYFuPGqL8WTfYC9tokJP-_1KI6-S58ZcA6TvN5DgbrUHBIz8u9aEsankBm_gjLrbrZmhrF0DJksQVdkYS6sqRPi6dbHSOlVMKpuQAxqs2jqm1mMx6K1WflbeuxXafF8U5NfDua6iFP4uWUUPEsUM9dhO9MdUNOeKEW1cVPkYDUnmOGtNH0uJJnF40hyb1krvTF2FwINuYqLfQ8Oz98p9IVhWFtelWESd_eWmmmTKpmM3Iv1mkysR492k1aplPO_u5Jah-8k-Bidpz4hHzwg-LfF3Fd_4PCaiBi2Z5_AVoQLGXt-cxe0jNMW3u24S8pPNNwuhv5MEUBq4GSaNcEn2cdjp8NfvLYX4qk5XYVcZKRWgNGFLF2q1g1qGaTeiA-frn-Jh1Ows9QZiFy2srBeiabm5dJcd-z88uVJ__-lJ89GUoT-Rp7-OQmbHldOZFwSiyXiOfvOz1nkOTBESAOCPpaAPtofb5gBiFb15-AwWWA",
"expiry":360,
"errorDetails":null
}';
p_out := substr(buffer,instr(buffer,':"') + 2,instr(buffer,'token_type') - 21);
end;
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}