Oracle | URIFACTORY

Oracle URIFACTORY Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Utilities for modifying URLs

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	FTPURITYPE	URITYPE
DBMS_CLOBUTIL	HTTPURITYPE	UTL_HTTP
DBMS_XMLGEN	PLITBLM	UTL_URL
DBMS_XMLSCHEMA	URIFACELEM	XDBURITYPE
DBURITYPE	URIFACLIST

Documented No

First Available Not Known

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsuri.sql

Subprograms

ESCAPEURI	REGISTERURLHANDLER	UNREGISTERURLHANDLER
GETURI	UNESCAPEURI

ESCAPEURI

Returns the correct uritype urifactory.escapeURI(unescapedurl IN VARCHAR2) RETURN VARCHAR2;

SELECT urifactory.escapeURI('https://www.morganslibrary.com/a url with space.html')

      FROM dual;

      

      URIFACTORY.ESCAPEURI('HTTPS://WWW.MORGANSLIBRARY.COM/AURLWITHSPACE.HTML')

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

      https://www.morganslibrary.com/a%20url%20with%20space.html

GETURI

Returns the correct uritype urifactory.getURI(url IN VARCHAR2) RETURN UriType;

SELECT urifactory.getURI('https://www.dbsecworx.com')

      FROM dual;

      

      URIFACTORY.GETURI('HTTPS://WWW.DBSECWORX.COM')(URL)

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

      XDBURITYPE('https://www.dbsecworx.com', NULL)

REGISTERURLHANDLER

Registers a url handler urifactory.registerURLHandler( prefix IN VARCHAR2, schemaname IN VARCHAR2, typename IN VARCHAR2, ignorePrefixCase IN BOOLEAN := TRUE, stripprefix IN BOOLEAN := TRUE);

TBD

UNESCAPEURI

Returns the correct uritype urifactory.unescapeURI(escapedurl IN VARCHAR2) RETURN VARCHAR2;

SELECT urifactory.unescapeURI('https://%20www.dbsecworx.com')

      FROM dual;

      

      URIFACTORY.UNESCAPEURI('HTTPS://%20WWW.DBSECWORX.COM')

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

      https:// www.dbsecworx.com

UNREGISTERURLHANDLER

Unregisters a URL handler urifactory.unregisterURLHandler(prefix IN VARCHAR2);

TBD