Oracle | UTL

Oracle UTL_URL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Escape/Unescape URLs

AUTHID DEFINER

Dependencies

DBMS_ISCHED	SPARQL_SERVICE_IMPL_T	UTL_RPADV
DBMS_ISCHED_REMOTE_ACCESS	URIFACTORY	UTL_URL_LIB
SDO_RDF	UTL_HTTP

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;

SQL> SELECT utl_url.escape('http://www.mlib.com/a url with space.html')

        2  FROM dual;

      

      UTL_URL.ESCAPE('HTTP://WWW.MLIB.COM/AURLWITHSPACE.HTML')

      ---------------------------------------------------------

      http://www.acme.com/a%20url%20with%20space.html

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;

SQL> SELECT utl_url.unescape('http://www.mlib.com/a%20url%20with%20space.html')

        2  FROM dual;

      

      UTL_URL.UNESCAPE('HTTP://WWW.MLIB.COM/A%20URL%20WITH%20SPACE.HTML')

      --------------------------------------------------------------------

      http://www.mlib.com/a url with space.html