1 PACKAGE drival AS
2
3 function validate_pref(
4 p_pref_name varchar2,
5 p_class_id number
6 ) return dr_def.pref_rec;
7
8 procedure validate_attr(p_pref in dr_def.pref_rec,
9 p_attr_name in varchar2,
10 p_attr_value in out varchar2);
11
12 /*----------------------- ValidateCTXRULEOptions -----------------------*/
13 /*
14 NAME
15 ValidateCTXRULEOptions
16
17 DESCRIPTION
18 Validate the attributes used during the construction of a CTXRULE index.
19 The invalid attribute value are:
20 * PREFIX_INDEX can not be set to TRUE
21 * SUBSTRING_INDEX can not be set to TRUE
22
23 ARGUMENTS
24 opts - a creation record
25
26 NOTES
27 This function was added for Bug 5237224.
28
29 EXCEPTIONS
30 DRIG.QE_CTXRULE_INVALIDATTR is raised if an invalid attribute
31 value is present. It has two possible arguments. These are
32 'PREFIX_INDEX' or 'SUBSTRING_INDEX'.
33
34 RETURNS
35 0 if the attributes are acceptable
36 1 if the attribute settings can not be used in a CTXRULE index.
37
38 */
39 FUNCTION ValidateCTXRULEOptions (
40 opts driparse.createrec
41 ) return number;
42
43 end drival;