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
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
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="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://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="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://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="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://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="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://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;
/