1 PACKAGE dbms_xmltableindex AUTHID CURRENT_USER AS
2 ----------------------------------------------------------------------------
3 -- PROCEDURE - RebuildIndex
4 -- Rebuild an XMLTABLE index with the new XMLTable clause.
5 -- PARAMETERS -
6 -- index_schema
7 -- Schema of the XMLTableIndex
8 -- index_name
9 -- Name of the XMLTableIndex
10 -- index_clause
11 -- XMLTable clause for the index. This will replace the original
12 -- XMLTable clause in the parameter clause of CREATE INDEX statement.
13 ----------------------------------------------------------------------------
14 PROCEDURE AlterIndexModify(index_owner IN VARCHAR2,
15 index_name IN VARCHAR2,
16 index_group IN VARCHAR2,
17 index_table IN VARCHAR2,
18 index_column IN VARCHAR2,
19 index_clause IN CLOB);
20
21 PROCEDURE AlterIndexAddGroup(index_owner IN VARCHAR2,
22 index_name IN VARCHAR2,
23 index_group IN VARCHAR2,
24 index_table IN VARCHAR2,
25 index_column IN VARCHAR2,
26 index_clause IN CLOB);
27
28 PROCEDURE AlterIndexDropGroup(index_owner IN VARCHAR2,
29 index_name IN VARCHAR2,
30 index_group IN VARCHAR2);
31
32 PROCEDURE AlterIndexDropColumn(index_owner IN VARCHAR2,
33 index_name IN VARCHAR2,
34 index_group IN VARCHAR2,
35 index_cont_table IN VARCHAR2,
36 index_cont_column IN VARCHAR2);
37
38 PROCEDURE AlterIndexAddColumn(index_owner IN VARCHAR2,
39 index_name IN VARCHAR2,
40 index_group IN VARCHAR2,
41 index_table IN VARCHAR2,
42 index_column IN VARCHAR2,
43 index_clause IN CLOB );
44
45 PROCEDURE AlterIndexRenameColumn(index_owner IN VARCHAR2,
46 index_name IN VARCHAR2,
47 index_group IN VARCHAR2,
48 index_cont_table IN VARCHAR2,
49 index_old_cont_column IN VARCHAR2,
50 index_new_cont_column IN VARCHAR2);
51
52 PROCEDURE CreateIndex(index_owner IN VARCHAR2,
53 index_name IN VARCHAR2,
54 index_table IN VARCHAR2,
55 index_column IN VARCHAR2,
56 index_clause IN CLOB );
57
58 end dbms_xmltableindex;