| General Information |
| Purpose |
Escape/Unescape URLs |
| Source |
{ORACLE_HOME}/rdbms/admin/utlurl.sql |
| First Availability |
9.0.1 |
| Dependencies |
| DBMS_ISCHED |
UTL_HTTP |
WWV_FLOW_UTILITIES |
| URIFACTORY |
UTL_URL_LIB |
WWV_HTF |
|
| 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; |
