1 PACKAGE hr_utf8_triggers AUTHID CURRENT_USER AS
2 /* $Header: hrutf8tr.pkh 120.2.12000000.1 2007/01/21 19:14:54 appldev ship $ */
3
4 /*
5 +==========================================================================+
6 | Copyright (c) 2002 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==========================================================================+
10 Name
11 HR Functionality to maintain UTF8 triggers.
12 Purpose
13 The procedures within dynamically create or drop database triggers
14 for UTF8. These triggers validate the length of columns based on
15 their pre-UTF8 length and raise a message if the value has been
16 exceeded in length.
17
18 This includes several procedures: one initialises a static
19 global pl/sql table of triggers and the other, modify_all_triggers,
20 creates, modifies or drops all UTF8 triggers listed in the plsql
21 table.
22
23 It takes a single parameter, p_restriction_mode which can take the
24 following values:
25 <NULL> Defaults to whatever is in pay_action_parameters. If this
26 row does not exist it creates one using BYTE.
27 BYTE The triggers restrict the length using lengthb to the
28 pre-extended column value. All character sets continue
29 as if the columns were never extended in length.
30 CHAR The triggers restrict using length so the characters
31 available remain the same regardless of the character set.
32 A multi-byte character set will typically have 3 times
33 as many characters available. Single-byte character sets
34 will behave as if the length was never extended.
35 UNRESTRICTED All UTF8 triggers will be dropped. The extended
36 column definitions are available to all character
37 sets so will typically allow 3 times as many
38 characters, e.g., a length of 50 that has been
39 extended to 150 means that 150 characters can be
40 used in a single-byte character set and 50
41 characters can be used in a 3-byte character set.
42
43 Change History
44 -------+--------+-----------+-------+--------------------------------------|
45 dcasemor 25-MAR-2002 115.0 Created.
46 dcasemor 15-APR-2002 115.1 Added chk_utf8_col_lengths. This
47 procedure is used exclusively by
48 PERWSHRG and should be nulled out when
49 a standalone patch is delivered to
50 drop the constraints.
51 dcasemor 02-JUL-2002 115.2 Renamed create_all_triggers to
52 modify_all_triggers and made
53 drop_all_triggers private.
54 brsinha 08-JUL-2006 120.2 Changed for bug # 5353498
55 This file is obsoleted in R12.
56 As the package is not required anymore.
57 ---------------------------------------------------------------------------|
58 */
59
60 /** This Package has been obsoleted. Bug # 5353498 **/
61
62
63 END hr_utf8_triggers;