CREATE OR REPLACE procedure altertrigs wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
7
9000000
1
4
0
23
2 :e:
1ALTERTRIGS:
1B_ENABLE:
1VARCHAR2:
1WDB_SCHEMA:
1POLICY_NAME:
1WEBDB_VPD_POLICY:
1BUFFER:
12000:
1Y:
1NUMBER:
10:
1X:
1OBJECT_NAME:
1ALL_OBJECTS:
1OWNER:
1UPPER:
1OBJECT_TYPE:
1ALL_POLICIES:
1OBJECT_OWNER:
1select OBJECT_NAME from ALL_OBJECTS:n                where OWNER = upper(WDB_+
1SCHEMA):n                  and OBJECT_TYPE = 'TABLE':n                  and O+
1BJECT_NAME in (select OBJECT_NAME from ALL_POLICIES:n                        +
1     where POLICY_NAME=upper(policy_name):n                               and+
1 OBJECT_OWNER=upper(WDB_SCHEMA)) :
1LOOP:
1alter table :
1||:
1.:
1 :
1 all triggers:
1EXECUTE:
1IMMEDIATE:
1+:
11:
1DBMS_OUTPUT:
1PUT_LINE:
1Number of triggers :
1LOWER:
1d are:: :
0

0
0
7f
2
0 9a 8f a0 b0 3d 8f a0
b0 3d 8f a0 6e b0 3d b4
55 6a a3 a0 51 a5 1c 81
b0 a3 a0 1c 51 81 b0 91
:f a0 12a 37 :2 a0 6e 7e :2 a0 a5
b b4 2e 7e 6e b4 2e 7e
:2 a0 6b b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
d :3 a0 11e 11d :2 a0 7e 51 b4
2e d b7 a0 47 :2 a0 6b 6e
7e :2 a0 a5 b b4 2e 7e 6e
b4 2e 7e a0 b4 2e a5 57
b7 a4 b1 11 68 4f 1d 17
b5
7f
2
0 3 1f 1b 1a 27 34 30
17 3c 4a 41 45 2f 52 2c
57 5b 78 63 67 6a 6b 73
62 94 83 87 5f 8f 82 9b
9f a3 a7 ab af b3 b7 bb
bf c3 c7 cb cf d3 d7 db
7f e7 eb ef f4 f7 fb ff
100 102 103 108 10b 110 111 116
119 11d 121 124 125 12a 12d 132
133 138 13b 13f 140 145 148 14d
14e 153 157 15b 15f 163 168 16c
170 174 177 17a 17b 180 184 186
18a 191 195 199 19c 1a1 1a4 1a8
1ac 1ad 1af 1b0 1b5 1b8 1bd 1be
1c3 1c6 1ca 1cb 1d0 1d1 1d6 1d8
1dc 1de 1ea 1ee 1f0 1f1 1fa
7f
2
0 b 16 1f :2 16 29 34 :2 29
1f 2b 3c :2 1f 15 :2 1 4 f
18 17 :2 f :2 4 :2 f 19 f 4
5 12 23 17 1f 25 :2 17 2e
3f 24 30 36 24 31 37 a
:2 1 6 10 1f 23 29 :2 23 :2 10
35 38 :2 10 3c 11 :2 13 :2 10 1f
22 :2 10 26 29 :2 10 33 36 :2 10
:2 6 e 18 :3 6 b d f :2 b
6 1 5 :2 1 :2 d 16 2c 2f
35 :2 2f :3 16 19 :2 16 23 26 :2 16
:b 1
7f
4
0 :9 1 :5 2 :3 1
:7 4 :6 5 :3 7 :3 8
9 :3 a :3 b :3 c
:2 7 d :e f :3 10
:2 f :2 10 :2 f :2 10
:2 f :2 10 :3 f :5 11
:7 12 d 13 7
:b 14 :2 15 :2 14 :2 15
:4 14 :2 6 :7 1
1fc
4
:3 0 1 :a 0 7a
1 :7 0 5 2c
0 :2 3 :3 0 2
:7 0 4 3 :3 0
9 :2 0 7 3
:3 0 4 :7 0 8
7 :3 0 3 :3 0
6 :4 0 5 :7 0
d b c :2 0
f :2 0 7a 1
10 :2 0 b :2 0
f 3 :3 0 8
:2 0 d 13 15
:6 0 18 16 0
78 0 7 :6 0
1f 2f 0 11
a :3 0 1a :7 0
1e 1b 1c 78
0 9 :6 0 c
:3 0 d :3 0 e
:3 0 f :3 0 10
:3 0 4 :3 0 11
:3 0 d :3 0 d
:3 0 12 :3 0 5
:3 0 10 :3 0 5
:3 0 13 :3 0 10
:3 0 4 :4 0 14
1 :8 0 30 15
:3 0 7 :3 0 16
:4 0 17 :2 0 10
:3 0 4 :3 0 13
35 37 15 34
39 :3 0 17 :2 0
18 :4 0 18 3b
3d :3 0 17 :2 0
c :3 0 d :3 0
40 41 0 1b
3f 43 :3 0 17
:2 0 19 :4 0 1e
45 47 :3 0 17
:2 0 2 :3 0 21
49 4b :3 0 17
:2 0 1a :4 0 24
4d 4f :3 0 32
50 0 5e 1b
:3 0 1c :3 0 7
:3 0 54 :4 0 55
:2 0 5e 9 :3 0
9 :3 0 1d :2 0
1e :2 0 27 59
5b :3 0 57 5c
0 5e 2a 60
15 :3 0 30 5e
:4 0 76 1f :3 0
20 :3 0 61 62
0 21 :4 0 17
:2 0 22 :3 0 2
:3 0 2e 66 68
30 65 6a :3 0
17 :2 0 23 :4 0
33 6c 6e :3 0
17 :2 0 9 :3 0
36 70 72 :3 0
39 63 74 :2 0
76 3b 79 :3 0
79 3e 79 78
76 77 :6 0 7a
:2 0 1 10 79
7d :3 0 7c 7a
7e :8 0
41
4
:3 0 1 2 1
6 1 a 3
5 9 e 1
14 1 12 1
19 1 36 2
33 38 2 3a
3c 2 3e 42
2 44 46 2
48 4a 2 4c
4e 2 58 5a
3 51 56 5d
1 67 2 64
69 2 6b 6d
2 6f 71 1
73 2 60 75
2 17 1d
1
4
0
7d
0
1
14
2
7
0 1 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0
a 1 0
12 1 0
1 0 1
6 1 0
1f 2 0
19 1 0
2 1 0
0
/