Search the Reference Library pages:  

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 |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----