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
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;
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