CREATE OR REPLACE PROCEDURE EXEC_DONT_FAIL wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
7
9200000
1
4
0 
e
2 :e:
1EXEC_DONT_FAIL:
1P_CMD:
1VARCHAR2:
1E_TABLE_OR_VIEW_DOES_NOT_EXIST:
1PRAGMA:
1EXCEPTION_INIT:
1-:
1942:
1E_TYPE_DOES_NOT_EXIST:
14043:
1E_SEQUENCE_DOES_NOT_EXIST:
12289:
1EXECUTE:
1IMMEDIATE:
0

0
0
42
2
0 9a 8f a0 b0 3d b4 55
6a 8b b0 2a :3 a0 7e 51 b4
2e b4 5d 8b b0 2a :3 a0 7e
51 b4 2e b4 5d 8b b0 2a
:3 a0 7e 51 b4 2e b4 5d :3 a0
11e 11d b7 :3 a0 4f b7 a6 9
a4 b1 11 68 4f 1d 17 b5 
42
2
0 3 1f 1b 1a 27 17 2c
30 34 3b 3c 3f 43 47 4b
4e 51 52 57 58 5b 62 63
66 6a 6e 72 75 78 79 7e
7f 82 89 8a 8d 91 95 99
9c 9f a0 a5 a6 a9 ad b1
b5 ba be c0 c4 c8 cc ce
d0 d1 d6 da dc e8 ec ee
ef f8 
42
2
0 b 1b 24 :2 1b 19 :2 1 :4 5
c 1b :4 3b :5 5 2 9 18 :4 2f
:6 2 9 18 :4 33 :2 2 4 c 16
:2 4 1 7 29 42 4 5c :2 2
:8 1 
42
4
0 :8 1 :3 2 :9 3
:3 4 :9 5 :3 6 :9 7
:5 9 8 :3 b c
:3 b a :7 1 
fa
4
:3 0 1 :a 0 3d
1 :7 0 5 :2 0
:2 3 :3 0 2 :7 0
4 3 :3 0 6
:2 0 3d 1 7
:2 0 4 :6 0 7
a 0 3b 5
:3 0 6 :3 0 4
9 :2 0 7 :2 0
8 :2 0 9 f
11 :3 0 b d
13 3b 9 :6 0
e 16 0 3b
5 :3 0 6 :3 0
9 15 :2 0 7
:2 0 a :2 0 10
1b 1d :3 0 12
19 1f 3b b
:6 0 15 22 0
3b 5 :3 0 6
:3 0 b 21 :2 0
7 :2 0 c :2 0
17 27 29 :3 0
19 25 2b 3b
d :3 0 e :3 0
2 :3 0 2f :4 0
30 :2 0 32 1c
3c 4 :3 0 9
:3 0 b :4 0 37
1e 39 20 38
37 :2 0 3a 24
:2 0 3c 26 3c
3b 32 3a :6 0
3d :2 0 1 7
3c 40 :3 0 3f
3d 41 :8 0 
2d
4
:3 0 1 2 1
5 1 9 1
10 2 e 12
1 15 1 1c
2 1a 1e 1
21 1 28 2
26 2a 1 31
1 36 3 33
34 35 1 39
6 b 14 17
20 23 2c 
1
4
0 
40
0
1
14
1
5
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 
1 0 1
2 1 0
9 1 0
21 1 0
15 1 0
0

/
DECLARE
BEGIN
	EXEC_DONT_FAIL('DROP TYPE DEP_OBJECTLIST');
	EXEC_DONT_FAIL('DROP TYPE DEP_OBJECT');
    EXEC_DONT_FAIL('DROP TYPE PrecedenceObjList');
	EXEC_DONT_FAIL('DROP TABLE dataflow_dependency_t');
END;
/
DROP PROCEDURE EXEC_DONT_FAIL;
CREATE TYPE PrecedenceObjList AS VARRAY(600) OF VARCHAR2(100);
/
CREATE TYPE DEP_OBJECT wrapped 
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
d
9200000
1
4
0 
27
2 :e:
1TYPE:
1DEP_OBJECT:
1OBJECT:
1OBJECT_ID:
1NUMBER:
19:
1OBJECT_UOID:
1VARCHAR2:
1255:
1OBJECT_NAME:
1OBJECT_LOGICAL_NAME:
1OBJECT_CLASSNAME:
1OBJECT_STRONGTYPENAME:
1OBJECT_ICONTYPE:
1GROUP_ID:
1GROUP_UOID:
1GROUP_NAME:
1GROUP_LOGICAL_NAME:
1GROUP_CLASSNAME:
1GROUP_STRONGTYPENAME:
1GROUP_ICONTYPE:
1PARENT_ID:
1PARENT_UOID:
1PARENT_NAME:
1PARENT_LOGICAL_NAME:
1PARENT_CLASSNAME:
1PARENT_STRONGTYPENAME:
1PARENT_ICONTYPE:
1FOLDER_ID:
1FOLDER_UOID:
1FOLDER_NAME:
1FOLDER_LOGICAL_NAME:
1FOLDER_CLASSNAME:
1FOLDER_STRONGTYPENAME:
1FOLDER_ICONTYPE:
1PREBOUNDTYPE:
120:
1PRECEDENCE_OBJECTS:
1PRECEDENCEOBJLIST:
0

0
0
dd
2
0 a0 9d a0 60 a3 a0 51
a5 1c b0 81 a3 a0 51 a5
1c b0 81 a3 a0 51 a5 1c
b0 81 a3 a0 51 a5 1c b0
81 a3 a0 51 a5 1c b0 81
a3 a0 51 a5 1c b0 81 a3
a0 51 a5 1c b0 81 a3 a0
51 a5 1c b0 81 a3 a0 51
a5 1c b0 81 a3 a0 51 a5
1c b0 81 a3 a0 51 a5 1c
b0 81 a3 a0 51 a5 1c b0
81 a3 a0 51 a5 1c b0 81
a3 a0 51 a5 1c b0 81 a3
a0 51 a5 1c b0 81 a3 a0
51 a5 1c b0 81 a3 a0 51
a5 1c b0 81 a3 a0 51 a5
1c b0 81 a3 a0 51 a5 1c
b0 81 a3 a0 51 a5 1c b0
81 a3 a0 51 a5 1c b0 81
a3 a0 51 a5 1c b0 81 a3
a0 51 a5 1c b0 81 a3 a0
51 a5 1c b0 81 a3 a0 51
a5 1c b0 81 a3 a0 51 a5
1c b0 81 a3 a0 51 a5 1c
b0 81 a3 a0 51 a5 1c b0
81 a3 a0 51 a5 1c b0 81
a3 a0 1c b0 81 77 a0 102
a0 c6 1d 17 b5 
dd
2
0 3 387 b f 33 23 27
2a 2b 22 3a 50 43 1f 47
48 42 57 6d 60 3f 64 65
5f 74 8a 7d 5c 81 82 7c
91 a7 9a 79 9e 9f 99 ae
c4 b7 96 bb bc b6 cb e1
d4 b3 d8 d9 d3 e8 fe f1
d0 f5 f6 f0 105 11b 10e ed
112 113 10d 122 138 12b 10a 12f
130 12a 13f 155 148 127 14c 14d
147 15c 172 165 144 169 16a 164
179 18f 182 161 186 187 181 196
1ac 19f 17e 1a3 1a4 19e 1b3 1c9
1bc 19b 1c0 1c1 1bb 1d0 1e6 1d9
1b8 1dd 1de 1d8 1ed 203 1f6 1d5
1fa 1fb 1f5 20a 220 213 1f2 217
218 212 227 23d 230 20f 234 235
22f 244 25a 24d 22c 251 252 24c
261 277 26a 249 26e 26f 269 27e
294 287 266 28b 28c 286 29b 2b1
2a4 283 2a8 2a9 2a3 2b8 2ce 2c1
2a0 2c5 2c6 2c0 2d5 2eb 2de 2bd
2e2 2e3 2dd 2f2 308 2fb 2da 2ff
300 2fa 30f 325 318 2f7 31c 31d
317 32c 342 335 314 339 33a 334
349 35f 352 331 356 357 351 366
37b 36f 373 34e 382 36b 7 38e
390 394 396 397 3a0 
dd
2
0 1 6 14 1 4 e 15
14 e :3 4 10 19 18 10 :3 4
10 19 18 10 :3 4 18 21 20
18 :3 4 15 1e 1d 15 :3 4 1a
23 22 1a :3 4 14 1d 1c 14
:3 4 d 14 13 d :3 4 f 18
17 f :3 4 f 18 17 f :3 4
17 20 1f 17 :3 4 14 1d 1c
14 :3 4 19 22 21 19 :3 4 13
1c 1b 13 :3 4 e 15 14 e
:3 4 10 19 18 10 :3 4 10 19
18 10 :3 4 18 21 20 18 :3 4
15 1e 1d 15 :3 4 1a 23 22
1a :3 4 14 1d 1c 14 :3 4 e
15 14 e :3 4 10 19 18 10
:3 4 10 19 18 10 :3 4 18 21
20 18 :3 4 15 1e 1d 15 :3 4
1a 23 22 1a :3 4 14 1d 1c
14 :3 4 11 1a 19 11 :3 4 :2 17
:2 4 1 :2 2 :5 1 
dd
4
0 :4 1 :7 2 :7 3
:7 4 :7 5 :7 6 :7 7
:7 8 :7 9 :7 a :7 b
:7 c :7 d :7 e :7 f
:7 10 :7 11 :7 12 :7 13
:7 14 :7 15 :7 16 :7 17
:7 18 :7 19 :7 1a :7 1b
:7 1c :7 1d :7 1e :5 1f
1 :2 20 :5 1 
3a2
4
:3 0 1 :3 0 2
:3 0 3 :3 0 79
:3 0 d7 1 d5
:9 0 9 :2 0 :2 5
:3 0 6 :2 0 3
6 8 :6 0 4
:6 0 a 9 0
4 0 9 :2 0
9 8 :3 0 7
d f :6 0 7
:6 0 11 10 0
4 0 9 :2 0
d 8 :3 0 b
14 16 :6 0 a
:6 0 18 17 0
4 0 9 :2 0
11 8 :3 0 f
1b 1d :6 0 b
:6 0 1f 1e 0
4 0 9 :2 0
15 8 :3 0 13
22 24 :6 0 c
:6 0 26 25 0
4 0 9 :2 0
19 8 :3 0 17
29 2b :6 0 d
:6 0 2d 2c 0
4 0 6 :2 0
1d 8 :3 0 1b
30 32 :6 0 e
:6 0 34 33 0
4 0 9 :2 0
21 5 :3 0 1f
37 39 :6 0 f
:6 0 3b 3a 0
4 0 9 :2 0
25 8 :3 0 23
3e 40 :6 0 10
:6 0 42 41 0
4 0 9 :2 0
29 8 :3 0 27
45 47 :6 0 11
:6 0 49 48 0
4 0 9 :2 0
2d 8 :3 0 2b
4c 4e :6 0 12
:6 0 50 4f 0
4 0 9 :2 0
31 8 :3 0 2f
53 55 :6 0 13
:6 0 57 56 0
4 0 9 :2 0
35 8 :3 0 33
5a 5c :6 0 14
:6 0 5e 5d 0
4 0 6 :2 0
39 8 :3 0 37
61 63 :6 0 15
:6 0 65 64 0
4 0 9 :2 0
3d 5 :3 0 3b
68 6a :6 0 16
:6 0 6c 6b 0
4 0 9 :2 0
41 8 :3 0 3f
6f 71 :6 0 17
:6 0 73 72 0
4 0 9 :2 0
45 8 :3 0 43
76 78 :6 0 18
:6 0 7a 79 0
4 0 9 :2 0
49 8 :3 0 47
7d 7f :6 0 19
:6 0 81 80 0
4 0 9 :2 0
4d 8 :3 0 4b
84 86 :6 0 1a
:6 0 88 87 0
4 0 9 :2 0
51 8 :3 0 4f
8b 8d :6 0 1b
:6 0 8f 8e 0
4 0 6 :2 0
55 8 :3 0 53
92 94 :6 0 1c
:6 0 96 95 0
4 0 9 :2 0
59 5 :3 0 57
99 9b :6 0 1d
:6 0 9d 9c 0
4 0 9 :2 0
5d 8 :3 0 5b
a0 a2 :6 0 1e
:6 0 a4 a3 0
4 0 9 :2 0
61 8 :3 0 5f
a7 a9 :6 0 1f
:6 0 ab aa 0
4 0 9 :2 0
65 8 :3 0 63
ae b0 :6 0 20
:6 0 b2 b1 0
4 0 9 :2 0
69 8 :3 0 67
b5 b7 :6 0 21
:6 0 b9 b8 0
4 0 9 :2 0
6d 8 :3 0 6b
bc be :6 0 22
:6 0 c0 bf 0
4 0 25 :2 0
71 8 :3 0 6f
c3 c5 :6 0 23
:6 0 c7 c6 0
4 0 77 36b
0 75 8 :3 0
73 ca cc :6 0
24 :6 0 ce cd
0 4 0 2
0 4 0 27
:3 0 d1 :7 0 26
:6 0 d3 d2 0
4 0 2 4
2 1 :3 0 d6
0 2 :2 0 2
d8 d5 0 da
d9 dc :8 0 
98
4
:3 0 1 7 1
5 1 e 1
c 1 15 1
13 1 1c 1
1a 1 23 1
21 1 2a 1
28 1 31 1
2f 1 38 1
36 1 3f 1
3d 1 46 1
44 1 4d 1
4b 1 54 1
52 1 5b 1
59 1 62 1
60 1 69 1
67 1 70 1
6e 1 77 1
75 1 7e 1
7c 1 85 1
83 1 8c 1
8a 1 93 1
91 1 9a 1
98 1 a1 1
9f 1 a8 1
a6 1 af 1
ad 1 b6 1
b4 1 bd 1
bb 1 c4 1
c2 1 cb 1
c9 1 d0 1e
b 12 19 20
27 2e 35 3c
43 4a 51 58
5f 66 6d 74
7b 82 89 90
97 9e a5 ac
b3 ba c1 c8
cf d4 
1
4
0 
db
0
1
14
1
1f
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 
28 1 0
bb 1 0
7c 1 0
c9 1 0
2f 1 0
98 1 0
75 1 0
c2 1 0
6e 1 0
4b 1 0
8a 1 0
1a 1 0
d0 1 0
91 1 0
21 1 0
5 1 0
a6 1 0
9f 1 0
36 1 0
52 1 0
b4 1 0
ad 1 0
13 1 0
67 1 0
c 1 0
2 0 1
60 1 0
44 1 0
3d 1 0
59 1 0
83 1 0
0

/
CREATE TYPE DEP_OBJECTLIST IS VARRAY(600) OF DEP_OBJECT;
/
CREATE TABLE alldataflow_dependency_t (
   workspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null,
   source_comp_id NUMBER(9),
   source_entity_id NUMBER(9),
   source_param_id NUMBER(9),
   source_item_id NUMBER(9),
   target_param_id NUMBER(9),
   target_item_id NUMBER(9),
   target_comp_id NUMBER(9),
   target_entity_id NUMBER(9)
);
CREATE OR REPLACE VIEW dataflow_dependency_t (
   workspaceID,
   source_comp_id,
   source_entity_id,
   source_param_id,
   source_item_id,
   target_param_id,
   target_item_id,
   target_comp_id,
   target_entity_id
) as select
   workspaceID,
   source_comp_id,
   source_entity_id,
   source_param_id,
   source_item_id,
   target_param_id,
   target_item_id,
   target_comp_id,
   target_entity_id
from alldataflow_dependency_t
where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);