Oracle | XS_NAMESPACE

Oracle XS_NAMESPACE_INT 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 Real Application Security Namespace Management Internal Package

AUTHID DEFINER

Data Types -- the full DDL can be found in {ORACLE_HOME}/rdbms/admin/xsns.sql CREATE OR REPLACE NONEDITIONABLE TYPE sys.xs$ns_attribute_list AS VARRAY(1000) OF XS$NS_ATTRIBUTE; / CREATE OR REPLACE NONEDITIONABLE TYPE sys.xs$list IS VARRAY(1000) OF VARCHAR2(4000);

Dependencies

PLITBLM	XS$NSTMPL_ATTR	XS_ADMIN_INT
XS$LIST	XS$NS_ATTRIBUTE	XS_ADMIN_UTIL
XS$NSTMPL	XS$NS_ATTRIBUTE_LIST	XS_NAMESPACE

Documented Yes

First Available 12.1

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtns.plb

Subprograms

ADD_ATTRIBUTES	DELETE_TEMPLATE	SET_DESCRIPTION
CREATE_TEMPLATE	REMOVE_ATTRIBUTES	SET_HANDLER

ADD_ATTRIBUTES

Add a attributes to the namespace template

Overload 1 xs_namespace.add_attributes( template IN VARCHAR2, attribute IN VARCHAR2, default_value IN VARCHAR2 := NULL, attribute_events IN PLS_INTEGER := xs_namespace.no_event);

-- demo from Oracle RAS doc

      BEGIN

        sys.xs_namespace_int.add_attributes('POAttrs', 'item_type', 'generic',  xs_namespace.update_event);

        sys.xs_namespace_int.remove_attributes('POAttrs', 'item_type');

      END;

Add a attributes to the namespace template

Overload 2 xs_namespace.add_attributes( template IN VARCHAR2, attr_list IN xs$ns_attribute_list);

TBD

CREATE_TEMPLATE

Document creation API xs_namespace.create_template( name IN VARCHAR2, attr_list IN xs$ns_attribute_list := NULL, schema IN VARCHAR2 := NULL, package IN VARCHAR2 := NULL, function IN VARCHAR2 := NULL, acl IN VARCHAR2 := 'SYS.NS_UNRESTRICTED_ACL', description IN VARCHAR2 := NULL);

-- based on demo from Oracle RAS doc

      DECLARE

       attrlist xs$ns_attribute_list;

      BEGIN

        attrlist := xs$ns_attribute_list();

        attrlist.extend(2);

        attrlist(1) := xs$ns_attribute('desc', 'general');

        attrlist(2) := xs$ns_attribute(name=>'item_no',

        attribute_events => xs_namespace.firstread_event);

      

        sys.xs_namespace_int.create_template(POAttrs, attrlist, 'SH', 'order','fulfillment', 'sys.ns_unrestricted_acl', 'Purchase Order');

      END;

      /

      

      col acl format a20

      col description format a42

      

      SELECT name, acl, description

      FROM cdb_xs_ns_templates;

      

      col attribute format a23

      col namespace format a15

      col default_value format a20

      

      SELECT *

      FROM cdb_xs_ns_template_attributes;

DELETE_TEMPLATE

Delete the namespace template xs_namespace.delete_template( template IN VARCHAR2, delete_option IN PLS_INTEGER := xs_admin_util.default_option);

exec xs_namespace_int.delete_template('POAttrs',  xs_admin_util.cascade_option);

      

      PL/SQL procedure successfully completed.

REMOVE_ATTRIBUTES

Remove all attributes to the namespace template

Overload 1 xs_namespace.remove_attributes(template IN VARCHAR2);

exec sys.xs_namespace_int.remove_attributes('POAttrs');

      

      PL/SQL procedure successfully completed.

Remove a single attribute from the namespace template

Overload 2 xs_namespace.remove_attributes( template IN VARCHAR2, attribute IN VARCHAR2);

See ADD_ATTRIBUTES Demo Above

Remove a list of attribute from the namespace template

Overload 3 xs_namespace.remove_attributes( template IN VARCHAR2, attr_list IN XS$LIST);

TBD

SET_DESCRIPTION

Set namespace description xs_namespace.set_description( template IN VARCHAR2, description IN VARCHAR2);

exec sys.xs_namespace_int.set_description('POAttrs','Purchase Order Attributes');

      

      PL/SQL procedure successfully completed.

SET_HANDLER

Set handler for attribute events xs_namespace.set_handler( template IN VARCHAR2, schema IN VARCHAR2, package IN VARCHAR2, function IN VARCHAR2);

exec sys.xs_namespace_int.set_handler(POAttrs', 'SH', 'orders', 'populate_po');

      

      PL/SQL procedure successfully completed.