Facebook
From Sweltering Meerkat, 3 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 63
  1. declare
  2. p_out  varchar2(4000);
  3. buffer varchar2(4000);
  4.  
  5. buffer := '{
  6.  
  7. "status":1,
  8.  
  9. "accessToken":"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImppYk5ia0ZTU2JteFBZck45Q0ZxUms0SzRndyIsImtpZCI6ImppYk5ia0ZTU2JteFBZck45Q0ZxUms0SzRndyJ9.eyJhdWQiOiJodHRwczovL2dyYXBoLndpbmRvd3MubmV0IiwiaXNzIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvZjBjYTc4NWUtZGY4MC00ODU5LWE0MDEtYjIxZmU1MGYxYzBkLyIsImlhdCI6MTYwMDc3NjU0MywibmJmIjoxNjAwNzc2NTQzLCJleHAiOjE2MDA3ODA0NDMsImFjciI6IjEiLCJhaW8iOiJFMkJnWUhCUDRQaW0rK2hyaGNUUEFvM3dBMkoxSE9YN0Rwc2RQL1JFL2J6ZEVRWFcwMU1CIiwiYW1yIjpbInB3ZCJdLCJhcHBpZCI6IjJkMzk3MmM5LTI5ZDMtNGM4MC05YTEyLTBhYTE0MWZiMTg0YyIsImFwcGlkYWNyIjoiMSIsImlwYWRkciI6IjUyLjE3Mi4yMDMuMjIwIiwibmFtZSI6IkUtSW52b2ljZSBLZWxsb2coS0lQTCkiLCJvaWQiOiI0YWIzOGVmMy1iYTMxLTQwOTktYmM3YS1iNjIwNjgyNDM1OTAiLCJwdWlkIjoiMTAwMzIwMDBEOURCRDc4NCIsInJoIjoiMC5BQUFBWG5qSzhJRGZXVWlrQWJJZjVROGNEY2x5T1MzVEtZQk1taElLb1VIN0dFeEpBSEkuIiwic2NwIjoiRGlyZWN0b3J5LkFjY2Vzc0FzVXNlci5BbGwgRGlyZWN0b3J5LlJlYWQuQWxsIERpcmVjdG9yeS5SZWFkV3JpdGUuQWxsIEdyb3VwLlJlYWQuQWxsIEdyb3VwLlJlYWRXcml0ZS5BbGwgTWVtYmVyLlJlYWQuSGlkZGVuIFVzZXIuUmVhZCBVc2VyLlJlYWQuQWxsIFVzZXIuUmVhZEJhc2ljLkFsbCIsInN1YiI6InF1SjluNWwzMXhzYWM5UUZoSVRwRE1WaVhBekxmX0hFTTk0WGRGMEM2Q2siLCJ0ZW5hbnRfcmVnaW9uX3Njb3BlIjoiQVMiLCJ0aWQiOiJmMGNhNzg1ZS1kZjgwLTQ4NTktYTQwMS1iMjFmZTUwZjFjMGQiLCJ1bmlxdWVfbmFtZSI6ImVpbnZvaWNldXNlckBraXBsLmV5YXNwLmluIiwidXBuIjoiZWludm9pY2V1c2VyQGtpcGwuZXlhc3AuaW4iLCJ1dGkiOiIwdnFpaDdNMWZFcUZGVFByeGh0N0FBIiwidmVyIjoiMS4wIn0.ikTLdCpPDfMZ1lRXfEDcdiB8id2AiFMT3isfDMaWLtJuQdDVpm4i9VOaHT2Iw4Eqg3XemvYdHgrjafvjmo66RpShe54G4PDDfiMcykCqGnS52gRJEVZQGmksuxdjVo__FOeT0YrzwZVKoy-VLFzWE32ILo-oDU1BafpiKAWA4bgesnleytDCyb7GSz5BZqN0QNj0W2CIyPr7UPfIBG02pa2giq6dCYcvkVEH20ThhPnLpH57FuauHftHPXx7arPQ8ULhsbxp5q9xvScwMgQrljHthkoNY8YfItCRCRGfqTvxe2RJYcd4BntrsoVHR0lFw9tx_nMwt0y3KdPd2hnBzA",
  10.  
  11. "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",
  12.  
  13. "expiry":360,
  14.  
  15. "errorDetails":null
  16.  
  17. }';
  18. p_out := substr(buffer,instr(buffer,':"') + 2,instr(buffer,'token_type') - 21);
  19.  
  20. end;