Oracle | URIFACTORY

Oracle URIFACTORY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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	UROFACELEM	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 spacesS.html');

      

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

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

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

GETURI

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

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

      

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

      

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

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

      https:// www.dbsecworx.com

UNREGISTERURLHANDLER

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

TBD