CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

UTL_URL
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/utlurl.sql
First Availability 9.0.1
Dependencies
DBMS_ISCHED   URIFACTORY UTL_HTTP
Exceptions
Exception Name Error Code Reason
BAD_URL -29262 The URL contains badly formed escape code sequences
BAD_FIXED_WIDTH_CHARSET -29274 Fixed-width multibyte character set not allowed as a URL character set
Security Model Execute is granted to PUBLIC
 
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
UTL_INADDR
UTL_HTTP
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [33 users online]    © 2010 psoug.org