1 PACKAGE dbms_xmlstore AUTHID CURRENT_USER AS
2
3 -- context handle
4 SUBTYPE ctxHandle IS NUMBER;
5 SUBTYPE ctxType IS NUMBER;
6 SUBTYPE conversionType IS NUMBER;
7
8 -------------------- constructor/destructor functions ---------------------
9 FUNCTION newContext(targetTable IN VARCHAR2) RETURN ctxHandle;
10 PROCEDURE closeContext(ctxHdl IN ctxHandle);
11
12 -- set the row tag name
13 PROCEDURE setRowTag(ctx IN ctxHandle, rowTagName IN varchar2);
14
15 -- set the columns to update. Relevant for insert and update routines..
16 PROCEDURE setUpdateColumn(ctxHdl IN ctxType, colName IN VARCHAR2);
17 PROCEDURE clearUpdateColumnList(ctxHdl IN ctxType);
18
19 -- set the key column name to be used for updates and deletes.
20 PROCEDURE setKeyColumn(ctxHdl IN ctxType, colName IN VARCHAR2);
21 PROCEDURE clearKeyColumnList(ctxHdl IN ctxType);
22
23 -- set preserve whitespace
24 PROCEDURE setPreserveWhitespace(ctxHdl IN ctxType, flag IN BOOLEAN);
25
26 ------------------- save ----------------------------------------------------
27 -- insertXML
28 FUNCTION insertXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER;
29 FUNCTION insertXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER;
30 FUNCTION insertXML(ctxHdl IN ctxType, xDoc IN XMLTYPE) RETURN NUMBER;
31 -- updateXML
32 FUNCTION updateXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER;
33 FUNCTION updateXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER;
34 FUNCTION updateXML(ctxHdl IN ctxType, xDoc IN XMLTYPE) RETURN NUMBER;
35 -- deleteXML
36 FUNCTION deleteXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER;
37 FUNCTION deleteXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER;
38 FUNCTION deleteXML(ctxHdl IN ctxType, xDoc IN XMLTYPE) RETURN NUMBER;
39
40 END dbms_xmlstore;