Guest User

Untitled

a guest
May 5th, 2020
64
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create or replace function clob_to_xml return xmltype
  2. as
  3. l_clob clob;
  4. l_xml xmltype;
  5. begin
  6. l_clob :='<HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"></META>
  7. <TITLE>ERROR: The request could not be satisfied</TITLE>
  8. </HEAD><BODY>
  9. <H1>400 ERROR</H1>
  10. <H2>The request could not be satisfied.</H2>
  11. <HR noshade size="1px">
  12. Bad request.
  13. We can not connect to the server for this app or website at this time. There might be too much traffic or a configuration error. Try again later, or contact the app or website owner.
  14. <BR clear="all">
  15. If you provide content to customers through CloudFront, you can find steps to troubleshoot and help prevent this error by reviewing the CloudFront documentation.
  16. <BR clear="all">
  17. <HR noshade size="1px">
  18. <PRE>
  19. Generated by cloudfront (CloudFront)
  20. Request ID: OuFlfxj915qL9MRuJXsVcgVg990EyHMuVCo8VfGj3Qfc_MV1ou79cQ==
  21. </PRE>
  22. <ADDRESS>
  23. </ADDRESS>
  24. </BODY></HTML>';
  25. l_xml := xmltype(l_clob);
  26. return l_xml;
  27. end;
  28. /
  29.  
  30.  
  31.  
  32. declare
  33. r_xml xmltype;
  34. begin
  35. r_xml := clob_to_xml;
  36. end;
  37. /
RAW Paste Data