Oracle DBMS_XS_FIDM
Version 19.3

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 Undocumented. My demos all "work:" Meaning they don't create an exception. But I have no idea what they actually do if anything.
AUTHID CURRENT_USER
Dependencies
Only XMLTYPE    
Documented No
First Available 12.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmskzxp.sql
Subprograms
 
DBMS_XS_FIDM_DELETE
Undocumented dbms_xs_fidm_delete(contentXML IN XMLType) ;
DECLARE
 x XMLType := xmltype.createxml('<?xml version="1.0" encoding="utf-8"?>
       <ShoppingCartData xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
         <Id>Morgan</Id>
         <SiteId>1</SiteId>
         <ProductId>100</ProductId>
         <Quantity>2</Quantity>
       </ShoppingCartData>');
BEGIN
  dbms_xs_fidm.dbms_xs_fidm_delete(x);
END;
/
 
DBMS_XS_FIDM_INSERT
Undocumented dbms_xs_fidm_insert(contentXML IN XMLType) ;
DECLARE
 x XMLType := xmltype.createxml('<?xml version="1.0" encoding="utf-8"?>
       <ShoppingCartData xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
         <Id>Morgan</Id>
         <SiteId>1</SiteId>
         <ProductId>100</ProductId>
         <Quantity>2</Quantity>
       </ShoppingCartData>');
BEGIN
  dbms_xs_fidm.dbms_xs_fidm_insert(x);
END;
/
 
DBMS_XS_FIDM_UPDATE
Undocumented dbms_xs_fidm_update(contentXMLold IN XMLType, contentXMLnew IN XMLTYPE) ;
DECLARE
 o XMLType := xmltype.createxml('<?xml version="1.0" encoding="utf-8"?>
       <ShoppingCartData xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
         <Id>Morgan</Id>
         <SiteId>1</SiteId>
         <ProductId>100</ProductId>
         <Quantity>2</Quantity>
       </ShoppingCartData>');
 n XMLType := xmltype.createxml('<?xml version="1.0" encoding="utf-8"?>
       <ShoppingCartData xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
         <Id>Morgan</Id>
         <SiteId>1</SiteId>
         <ProductId>100</ProductId>
         <Quantity>0</Quantity>
       </ShoppingCartData>');
BEGIN
  dbms_xs_fidm.dbms_xs_fidm_update(o, n);
END;
/

Related Topics
Built-in Functions
Built-in Packages
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx