1 PACKAGE BODY DBMS_XMLSAVE AS
2
3 FUNCTION newContext(targetTable IN VARCHAR2) RETURN ctxType
4 as LANGUAGE JAVA NAME
5 'oracle.xml.sql.dml.OracleXMLStaticSave.newContext(java.lang.String) return int';
6
7 PROCEDURE closeContext(ctxHdl IN ctxType)
8 as LANGUAGE JAVA NAME
9 'oracle.xml.sql.dml.OracleXMLStaticSave.closeContext(int)';
10
11
12 PROCEDURE p_setXSLT(ctxHdl IN ctxType, uri IN VARCHAR2, ref IN VARCHAR2)
13 as LANGUAGE JAVA NAME
14 'oracle.xml.sql.dml.OracleXMLStaticSave.setXSLT(int, java.lang.String, java.lang.String)';
15
16 PROCEDURE setXSLT(ctxHdl IN ctxType, uri IN VARCHAR2, ref IN VARCHAR2 := null) IS
17 begin
18 p_setXSLT(ctxHdl, uri, ref);
19 end setXSLT;
20
21 PROCEDURE p_setXSLT(ctxHdl IN ctxType, stylesheet IN CLOB, ref IN VARCHAR2)
22 as LANGUAGE JAVA NAME
23 'oracle.xml.sql.dml.OracleXMLStaticSave.setXSLT(int, oracle.sql.CLOB, java.lang.String)';
24
25 PROCEDURE setXSLT(ctxHdl IN ctxType, stylesheet IN CLOB, ref IN VARCHAR2 := null) IS
26 begin
27 p_setXSLT(ctxHdl, stylesheet, ref);
28 end setXSLT;
29
30 PROCEDURE setXSLTParam(ctxHdl IN ctxType, name IN VARCHAR2,value IN VARCHAR2)
31 as LANGUAGE JAVA NAME
32 'oracle.xml.sql.dml.OracleXMLStaticSave.setXSLTParam(int, java.lang.String, java.lang.String)';
33
34 PROCEDURE removeXSLTParam(ctxHdl IN ctxType, name IN VARCHAR2)
35 as LANGUAGE JAVA NAME
36 'oracle.xml.sql.dml.OracleXMLStaticSave.removeXSLTParam(int, java.lang.String)';
37
38
39 PROCEDURE setRowTag(ctxHdl IN ctxType, tag IN VARCHAR2)
40 as LANGUAGE JAVA NAME
41 'oracle.xml.sql.dml.OracleXMLStaticSave.setRowTag(int, java.lang.String)';
42
43
44 PROCEDURE p_setSQLToXMLNameEsc(ctxHdl IN ctxType, flag IN NUMBER)
45 as LANGUAGE JAVA NAME
46 'oracle.xml.sql.dml.OracleXMLStaticSave.setSQLToXMLNameEscaping(int, byte)';
47
48 PROCEDURE setSQLToXMLNameEscaping(ctxHdl IN ctxType, flag IN BOOLEAN := true ) is
49 begin
50 if flag = true then
51 p_setSQLToXMLNameEsc(ctxHdl, 1);
52 else
53 p_setSQLToXMLNameEsc(ctxHdl, 0);
54 end if;
55 end setSQLToXMLNameEscaping;
56
57 PROCEDURE p_setPreserveWhitespace(ctxHdl IN ctxType, flag IN NUMBER)
58 as LANGUAGE JAVA NAME
59 'oracle.xml.sql.dml.OracleXMLStaticSave.setPreserveWhitespace(int, byte)';
60
61 PROCEDURE setPreserveWhitespace(ctxHdl IN ctxType,flag IN BOOLEAN := true) is
62 begin
63 if flag = true then
64 p_setPreserveWhitespace(ctxHdl, 1);
65 else
66 p_setPreserveWhitespace(ctxHdl, 0);
67 end if;
68 end setPreserveWhitespace;
69
70 PROCEDURE setIgnoreCase(ctxHdl IN ctxType, flag IN NUMBER)
71 as LANGUAGE JAVA NAME
72 'oracle.xml.sql.dml.OracleXMLStaticSave.setIgnoreCase(int, byte)';
73
74
75 PROCEDURE setDateFormat(ctxHdl IN ctxType, mask IN VARCHAR2)
76 as LANGUAGE JAVA NAME
77 'oracle.xml.sql.dml.OracleXMLStaticSave.setDateFormat(int, java.lang.String)';
78
79
80 PROCEDURE setBatchSize(ctxHdl IN ctxType, batchSize IN NUMBER)
81 as LANGUAGE JAVA NAME
82 'oracle.xml.sql.dml.OracleXMLStaticSave.setBatchSize(int, int)';
83
84
85 PROCEDURE setCommitBatch(ctxHdl IN ctxType, batchSize IN NUMBER)
86 as LANGUAGE JAVA NAME
87 'oracle.xml.sql.dml.OracleXMLStaticSave.setCommitBatch(int, int)';
88
89
90 PROCEDURE setUpdateColumn(ctxHdl IN ctxType, colName IN VARCHAR2)
91 as LANGUAGE JAVA NAME
92 'oracle.xml.sql.dml.OracleXMLStaticSave.setUpdateColumn(int, java.lang.String)';
93
94
95 PROCEDURE clearUpdateColumnList(ctxHdl IN ctxType)
96 as LANGUAGE JAVA NAME
97 'oracle.xml.sql.dml.OracleXMLStaticSave.clearUpdateColumnList(int)';
98
99
100 PROCEDURE setKeyColumn(ctxHdl IN ctxType, colName IN VARCHAR2)
101 as LANGUAGE JAVA NAME
102 'oracle.xml.sql.dml.OracleXMLStaticSave.setKeyColumn(int, java.lang.String)';
103
104
105 PROCEDURE clearKeyColumnList(ctxHdl IN ctxType)
106 as LANGUAGE JAVA NAME
107 'oracle.xml.sql.dml.OracleXMLStaticSave.clearKeyColumnList(int)';
108
109
110 ------------------- save ----------------------------------------------------
111 FUNCTION insertXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER
112 as LANGUAGE JAVA NAME
113 'oracle.xml.sql.dml.OracleXMLStaticSave.insertXML(int, java.lang.String) return int';
114
115 FUNCTION insertXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER
116 as LANGUAGE JAVA NAME
117 'oracle.xml.sql.dml.OracleXMLStaticSave.insertXML(int, oracle.sql.CLOB) return int';
118
119
120 FUNCTION updateXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER
121 as LANGUAGE JAVA NAME
122 'oracle.xml.sql.dml.OracleXMLStaticSave.updateXML(int, java.lang.String) return int';
123
124 FUNCTION updateXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER
125 as LANGUAGE JAVA NAME
126 'oracle.xml.sql.dml.OracleXMLStaticSave.updateXML(int, oracle.sql.CLOB) return int';
127
128
129 FUNCTION deleteXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER
130 as LANGUAGE JAVA NAME
131 'oracle.xml.sql.dml.OracleXMLStaticSave.deleteXML(int, java.lang.String) return int';
132
133 FUNCTION deleteXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER
134 as LANGUAGE JAVA NAME
135 'oracle.xml.sql.dml.OracleXMLStaticSave.deleteXML(int, oracle.sql.CLOB) return int';
136
137
138 ------------------- misc ----------------------------------------------------
139 PROCEDURE p_propagateOriginalException(ctxHdl IN ctxType, flag IN NUMBER)
140 as LANGUAGE JAVA NAME
141 'oracle.xml.sql.dml.OracleXMLStaticSave.propagateOriginalException(int, byte)';
142
143 PROCEDURE propagateOriginalException(ctxHdl IN ctxType, flag IN BOOLEAN) is
144 begin
145 if flag = true then
146 p_propagateOriginalException(ctxHdl, 1);
147 else
148 p_propagateOriginalException(ctxHdl, 0);
149 end if;
150 end propagateOriginalException;
151
152 PROCEDURE getExceptionContent(ctxHdl IN ctxType, errNo OUT NUMBER, errMsg OUT VARCHAR2)
153 as LANGUAGE JAVA NAME
154 'oracle.xml.sql.dml.OracleXMLStaticSave.getExceptionContent(int, int[], java.lang.String[])';
155
156 PROCEDURE p_useDBDates(ctxHdl IN ctxType, flag IN NUMBER)
157 as LANGUAGE JAVA NAME
158 'oracle.xml.sql.dml.OracleXMLStaticSave.useDBDates(int, byte)';
159
160 PROCEDURE useDBDates(ctxHdl IN ctxType, flag IN BOOLEAN := true) is
161 begin
162 if flag = true then
163 p_useDBDates(ctxHdl, 1);
164 else
165 p_useDBDates(ctxHdl, 0);
166 end if;
167 end useDBDates;
168
169 END DBMS_XMLSAVE;