Oracle 12cR2 UTL

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

UNESCAPE

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;