Oracle UTL_URL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Escape/Unescape URLs
AUTHID DEFINER
Dependencies
DBMS_ISCHED SPARQL_SERVICE_IMPL_T UTL_HTTP
DBMS_ISCHED_REMOTE_ACCESS URIFACTORY UTL_URL_LIB
SDO_RDF    
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;
SELECT utl_url.escape('http://www.acme.com/a url with space.html')
FROM dual;
 
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;
SELECT utl_url.unescape('http://www.acme.com/a%20url%20with%20space.html')
FROM dual;

Related Topics
Packages
UTL_HTTP
UTL_INADDR
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved