Oracle UTL_URL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Escape/Unescape URLs
AUTHID DEFINER
Dependencies
DBMS_ISCHED SPARQL_SERVICE_IMPL_T UTL_RPADV
DBMS_ISCHED_REMOTE_ACCESS URIFACTORY UTL_URL_LIB
SDO_RDF UTL_HTTP  
Documented Yes
Exceptions
Error Code Reason
ORA-29262 BAD_URL: The URL contains badly formed escape code sequences
ORA-29274 BAD_FIXED_WIDTH_CHARSET: Fixed-width multibyte character set not allowed as a URL character set
First Available 9.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/utlurl.sql
Subprograms
 
ESCAPE
Returns a URL with illegal characters (and optionally reserved characters) escaped using the %2-digit-hex-code format utl_url.escape(
url                   IN VARCHAR2 CHARACTER SET ANY_CS,
escape_reserved_chars IN BOOLEAN DEFAULT FALSE,
url_charset           IN VARCHAR2 DEFAULT utl_http.get_body_charset)
RETURN VARCHAR2 CHARACTER SET url%CHARSET;
SQL> SELECT utl_url.escape('http://www.mlib.com/a url with space.html')
  2  FROM dual;

UTL_URL.ESCAPE('HTTP://WWW.MLIB.COM/AURLWITHSPACE.HTML')
---------------------------------------------------------
http://www.acme.com/a%20url%20with%20space.html
 
UNESCAPE
This function unescapes the escape character sequences to its original form in a URL, to convert the %XX escape character sequences to the original characters. utl_url.escape(
url         IN VARCHAR2 CHARACTER SET ANY_CS,
url_charset IN VARCHAR2 utl_http.get_body_charset)
RETURN VARCHAR2 CHARACTER SET url%CHARSET;
SQL> SELECT utl_url.unescape('http://www.mlib.com/a%20url%20with%20space.html')
  2  FROM dual;

UTL_URL.UNESCAPE('HTTP://WWW.MLIB.COM/A%20URL%20WITH%20SPACE.HTML')
--------------------------------------------------------------------
http://www.mlib.com/a url with space.html

Related Topics
Built-in Functions
Built-in Packages
URIFACTORY
UTL_HTTP
UTL_INADDR
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx