Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_context_attr.plb
create or replace package body wb_rt_context_attr wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 9200000 1 4 0 32 2 :e: 1PACKAGE: 1BODY: 1WB_RT_CONTEXT_ATTR: 1CREATE_BINARY_ATTR: 1P_AUDIT_ID: 1NUMBER: 1P_ATTR_NAME: 1VARCHAR2: 1P_ATTR_VALUE: 1BLOB: 1L_COUNT: 1COUNT: 1WB_RT_BINARY_CONTEXT_ATTRS: 1AUDIT_ID: 1ATTR_NAME: 1UPPER: 1SELECT :n count(*) into l_count:n from :n wb_rt_binary_context_a+ 1ttrs:n where:n audit_id = p_audit_id and:n attr_name = upper(p_a+ 1ttr_name): 1=: 10: 1ATTR_VALUE: 1INSERT into wb_rt_binary_context_attrs:n (:n audit_id,:n a+ 1ttr_name,:n attr_value:n ):n values:n (:n p_audi+ 1t_id,:n upper(p_attr_name),:n p_attr_value:n ): 1UPDATE wb_rt_binary_context_attrs:n set:n attr_value = p_attr_val+ 1ue:n where:n audit_id = p_audit_id and:n attr_name = upper+ 1(p_attr_name): 1DELETE_BINARY_ATTR: 1DELETE from wb_rt_binary_context_attrs:n where:n audit_id = p_audit_i+ 1d and:n attr_name = upper(p_attr_name): 1CREATE_TEXTUAL_ATTR: 1CLOB: 1WB_RT_TEXTUAL_CONTEXT_ATTRS: 1SELECT :n count(*) into l_count:n from :n wb_rt_textual_context_+ 1attrs:n where:n audit_id = p_audit_id and:n attr_name = upper(p_+ 1attr_name): 1INSERT into wb_rt_textual_context_attrs:n (:n audit_id,:n + 1attr_name,:n attr_value:n ):n values:n (:n p_aud+ 1it_id,:n upper(p_attr_name),:n p_attr_value:n ): 1UPDATE wb_rt_textual_context_attrs:n set:n attr_value = p_attr_va+ 1lue:n where:n audit_id = p_audit_id and:n attr_name = uppe+ 1r(p_attr_name): 1FUNCTION: 1GET_TEXTUAL_ATTR: 1RETURN: 1L_VALUE: 1L_BUFFER: 14000: 1L_AMOUNT: 1SELECT :n attr_value :n into :n l_value:n from :n + 1 wb_rt_textual_context_attrs:n where :n audit_id = p_audit_id + 1and :n attr_name = upper(p_attr_name): 1NO_DATA_FOUND: 1WB_RTI_EXCEPTIONS: 1THROW: 1RT_INVALID_CONTEXT_ATTRIBUTE: 1DBMS_LOB: 1READ: 11: 1DELETE_TEXTUAL_ATTR: 1DELETE from wb_rt_textual_context_attrs:n where:n audit_id = p_audit_+ 1id and:n attr_name = upper(p_attr_name): 1DELETE_ALL_ATTRS: 1DELETE from wb_rt_binary_context_attrs:n where:n audit_id = p_audit_i+ 1d: 1DELETE from wb_rt_textual_context_attrs:n where:n audit_id = p_audit_+ 1id: 0 0 0 164 2 0 :2 a0 97 9a 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d b4 55 6a a3 a0 1c 81 b0 :8 a0 12a a0 7e 51 b4 2e :8 a0 12a b7 :8 a0 12a b7 :2 19 3c b7 a4 b1 11 68 4f 9a 8f a0 b0 3d 8f a0 b0 3d b4 55 6a :6 a0 12a b7 a4 b1 11 68 4f 9a 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d b4 55 6a a3 a0 1c 81 b0 :8 a0 12a a0 7e 51 b4 2e :8 a0 12a b7 :8 a0 12a b7 :2 19 3c b7 a4 b1 11 68 4f 9a 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d b4 55 6a a3 a0 1c 81 b0 :8 a0 12a a0 7e 51 b4 2e :8 a0 12a b7 :8 a0 12a b7 :2 19 3c b7 a4 b1 11 68 4f a0 8d 8f a0 b0 3d 8f a0 b0 3d b4 :2 a0 2c 6a a3 a0 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 1c 51 81 b0 :8 a0 12a b7 :3 a0 6b :2 a0 6b a5 57 b7 a6 9 a4 b1 11 4f :2 a0 6b :2 a0 51 a0 a5 57 :2 a0 65 b7 a4 b1 11 68 4f 9a 8f a0 b0 3d 8f a0 b0 3d b4 55 6a :6 a0 12a b7 a4 b1 11 68 4f 9a 8f a0 b0 3d b4 55 6a :3 a0 12a :3 a0 12a b7 a4 b1 11 68 4f b1 b7 a4 11 a0 b1 56 4f 1d 17 b5 164 2 0 3 7 b 15 31 2d 2c 39 46 42 29 4e 57 53 41 5f 3e 64 68 81 70 74 7c 6f 88 8c 90 94 98 9c a0 a4 a8 b4 6c b8 bb bc c1 c5 c9 cd d1 d5 d9 dd e1 ed ef f3 f7 fb ff 103 107 10b 10f 11b 11d 121 125 128 12a 12e 130 13c 140 142 15e 15a 159 166 173 16f 156 17b 16e 180 184 188 18c 190 194 198 19c 1a0 16b 1ac 1b0 1b2 1be 1c2 1c4 1e0 1dc 1db 1e8 1f5 1f1 1d8 1fd 206 202 1f0 20e 1ed 213 217 230 21f 223 22b 21e 237 23b 23f 243 247 24b 24f 253 257 263 21b 267 26a 26b 270 274 278 27c 280 284 288 28c 290 29c 29e 2a2 2a6 2aa 2ae 2b2 2b6 2ba 2be 2ca 2cc 2d0 2d4 2d7 2d9 2dd 2df 2eb 2ef 2f1 30d 309 308 315 322 31e 305 32a 333 32f 31d 33b 31a 340 344 35d 34c 350 358 34b 364 368 36c 370 374 378 37c 380 384 390 348 394 397 398 39d 3a1 3a5 3a9 3ad 3b1 3b5 3b9 3bd 3c9 3cb 3cf 3d3 3d7 3db 3df 3e3 3e7 3eb 3f7 3f9 3fd 401 404 406 40a 40c 418 41c 41e 422 43e 43a 439 446 453 44f 436 45b 44e 460 464 468 46c 485 474 478 480 44b 4a1 48c 490 493 494 49c 473 4bd 4ac 4b0 470 4b8 4ab 4c4 4c8 4cc 4d0 4d4 4d8 4dc 4e0 4e4 4a8 4f0 4f4 4f8 4fc 4ff 503 507 50a 50b 510 512 513 518 51c 51e 52a 52c 530 534 537 53b 53f 542 546 547 54c 550 554 558 55a 55e 560 56c 570 572 58e 58a 589 596 5a3 59f 586 5ab 59e 5b0 5b4 5b8 5bc 5c0 5c4 5c8 5cc 5d0 59b 5dc 5e0 5e2 5ee 5f2 5f4 610 60c 60b 618 608 61d 621 625 629 62d 631 63d 641 645 649 655 657 65b 65d 669 66d 66f 671 673 677 683 687 689 68c 68e 68f 698 164 2 0 1 9 e d 5 13 :3 5 14 :3 5 15 :2 5 :3 3 5 :3 d 5 7 15 :2 7 12 7 13 19 5 8 10 12 :2 10 13 :5 9 f 9 7 5 e 9 16 9 14 9 15 1b 7 :4 5 :6 3 d 5 13 :3 5 14 :2 5 :3 3 11 7 12 7 13 19 5 :6 3 d 5 13 :3 5 14 :3 5 15 :2 5 :3 3 5 :3 d 5 7 15 :2 7 12 7 13 19 5 8 10 12 :2 10 13 :5 9 f 9 7 5 e 9 16 9 14 9 15 1b 7 :4 5 :6 3 d 5 13 :3 5 14 :3 5 15 :2 5 :3 3 5 :3 d 5 7 15 :2 7 12 7 13 19 5 8 10 12 :2 10 13 :5 9 f 9 7 5 e 9 16 9 14 9 15 1b 7 :4 5 :7 3 c 5 13 :3 5 14 :2 5 :2 3 a :2 3 5 :3 d :2 5 e 17 16 :2 e :2 5 :2 e 18 e 5 :4 9 14 9 15 1b 7 5 c 9 :2 1b 21 :2 33 :2 9 :3 7 5 :3 3 5 :2 e 13 1c 26 29 :3 5 c 5 :6 3 d 5 13 :3 5 14 :2 5 :3 3 11 7 12 7 13 19 5 :6 3 d 5 13 :2 5 :3 3 11 7 12 5 11 7 12 5 :a 3 5 :6 1 164 4 0 :3 1 3 :4 5 :4 6 :4 7 4 :2 3 :5 a :2 e 10 :2 12 :3 13 d :5 15 18 1a 1b 1c 20 :2 21 22 18 16 27 :2 29 :2 2b :3 2c 27 25 :3 15 :2 b :4 3 32 :4 34 :4 35 33 :2 32 3a :2 3c :3 3d 3a :2 38 :4 32 41 :4 43 :4 44 :4 45 42 :2 41 :5 48 :2 4c 4e :2 50 :3 51 4b :5 53 56 58 59 5a 5e :2 5f 60 56 54 65 :2 67 :2 69 :3 6a 65 63 :3 53 :2 49 :4 41 70 :4 72 :4 73 :4 74 71 :2 70 :5 77 :2 7b 7d :2 7f :3 80 7a :5 82 85 87 88 89 8d :2 8e 8f 85 83 94 :2 96 :2 98 :3 99 94 92 :3 82 :2 78 :4 70 :2 9f :4 a1 :4 a2 a0 :2 a4 :2 9f :5 a6 :7 a7 :6 a8 ad af b1 :2 b3 :3 b4 ac ab b6 :8 b8 b7 :2 b6 b5 :3 a9 :9 bb :3 bd :2 a9 :4 9f c1 :4 c3 :4 c4 c2 :2 c1 c9 :2 cb :3 cc c9 :2 c7 :4 c1 d0 :4 d2 d1 :2 d0 d7 :2 d9 d7 db :2 dd db :2 d5 :4 d0 :4 3 e1 :6 1 69a 4 :3 0 1 :3 0 2 :3 0 3 :6 0 1 :2 0 4 :a 0 42 2 :7 0 5 3e 0 3 6 :3 0 5 :7 0 7 6 :3 0 9 :2 0 7 8 :3 0 7 :7 0 b a :3 0 a :3 0 9 :7 0 f e :3 0 11 :2 0 42 4 12 :2 0 12 :2 0 d 6 :3 0 15 :7 0 18 16 0 40 0 b :6 0 c :3 0 b :3 0 d :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 11 1 :8 0 3e b :3 0 13 :2 0 11 23 25 :3 0 d :3 0 e :3 0 f :3 0 14 :3 0 5 :3 0 10 :3 0 7 :3 0 9 :4 0 15 1 :8 0 30 14 3b d :3 0 14 :3 0 9 :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 16 1 :8 0 3a 16 3c 26 30 0 3d 0 3a 0 3d 18 0 3e 1b 41 :3 0 41 1e 41 40 3e 3f :6 0 42 1 0 4 12 41 15e :2 0 17 :a 0 5b 3 :7 0 22 16b 0 20 6 :3 0 5 :7 0 47 46 :3 0 27 5a 0 24 8 :3 0 7 :7 0 4b 4a :3 0 4d :2 0 5b 44 4e :2 0 d :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 18 1 :8 0 57 :3 0 5a 0 5a 59 57 58 :6 0 5b 1 0 44 4e 5a 15e :2 0 19 :a 0 9b 4 :7 0 2b 1ed 0 29 6 :3 0 5 :7 0 60 5f :3 0 2f :2 0 2d 8 :3 0 7 :7 0 64 63 :3 0 1a :3 0 9 :7 0 68 67 :3 0 6a :2 0 9b 5d 6b :2 0 12 :2 0 33 6 :3 0 6e :7 0 71 6f 0 99 0 b :6 0 c :3 0 b :3 0 1b :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 1c 1 :8 0 97 b :3 0 13 :2 0 37 7c 7e :3 0 1b :3 0 e :3 0 f :3 0 14 :3 0 5 :3 0 10 :3 0 7 :3 0 9 :4 0 1d 1 :8 0 89 3a 94 1b :3 0 14 :3 0 9 :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 1e 1 :8 0 93 3c 95 7f 89 0 96 0 93 0 96 3e 0 97 41 9a :3 0 9a 44 9a 99 97 98 :6 0 9b 1 0 5d 6b 9a 15e :2 0 19 :a 0 db 5 :7 0 48 31a 0 46 6 :3 0 5 :7 0 a0 9f :3 0 4c :2 0 4a 8 :3 0 7 :7 0 a4 a3 :3 0 8 :3 0 9 :7 0 a8 a7 :3 0 aa :2 0 db 9d ab :2 0 12 :2 0 50 6 :3 0 ae :7 0 b1 af 0 d9 0 b :6 0 c :3 0 b :3 0 1b :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 1c 1 :8 0 d7 b :3 0 13 :2 0 54 bc be :3 0 1b :3 0 e :3 0 f :3 0 14 :3 0 5 :3 0 10 :3 0 7 :3 0 9 :4 0 1d 1 :8 0 c9 57 d4 1b :3 0 14 :3 0 9 :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 1e 1 :8 0 d3 59 d5 bf c9 0 d6 0 d3 0 d6 5b 0 d7 5e da :3 0 da 61 da d9 d7 d8 :6 0 db 1 0 9d ab da 15e :2 0 1f :3 0 20 :a 0 128 6 :7 0 65 44b 0 63 6 :3 0 5 :7 0 e1 e0 :3 0 6a 470 0 67 8 :3 0 7 :7 0 e5 e4 :3 0 21 :3 0 8 :3 0 e7 e9 0 128 de ea :2 0 24 :2 0 6e 1a :3 0 ed :7 0 f0 ee 0 126 0 22 :6 0 8 :3 0 24 :2 0 6c f2 f4 :6 0 f7 f5 0 126 0 23 :6 0 72 116 0 70 6 :3 0 f9 :7 0 fd fa fb 126 0 25 :6 0 14 :3 0 22 :3 0 1b :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 26 1 :8 0 107 27 :3 0 28 :3 0 29 :3 0 109 10a 0 28 :3 0 2a :3 0 10c 10d 0 74 10b 10f :2 0 111 76 113 78 112 111 :2 0 114 7a :2 0 116 0 116 115 107 114 :6 0 124 6 :3 0 2b :3 0 2c :3 0 118 119 0 22 :3 0 25 :3 0 2d :2 0 23 :3 0 7c 11a 11f :2 0 124 21 :3 0 23 :3 0 122 :2 0 124 81 127 :3 0 127 85 127 126 124 125 :6 0 128 1 0 de ea 127 15e :2 0 2e :a 0 141 8 :7 0 8b 59b 0 89 6 :3 0 5 :7 0 12d 12c :3 0 90 140 0 8d 8 :3 0 7 :7 0 131 130 :3 0 133 :2 0 141 12a 134 :2 0 1b :3 0 e :3 0 5 :3 0 f :3 0 10 :3 0 7 :4 0 2f 1 :8 0 13d :3 0 140 0 140 13f 13d 13e :6 0 141 1 0 12a 134 140 15e :2 0 30 :a 0 157 9 :7 0 94 :2 0 92 6 :3 0 5 :7 0 146 145 :3 0 148 :2 0 157 143 149 :2 0 d :3 0 e :3 0 5 :4 0 31 1 :8 0 153 1b :3 0 e :3 0 5 :4 0 32 1 :8 0 153 96 156 :3 0 156 0 156 155 153 154 :6 0 157 1 0 143 149 156 15e :3 0 15c 0 15c :3 0 15c 15e 15a 15b :6 0 15f :2 0 3 :3 0 99 0 3 15c 162 :3 0 161 15f 163 :8 0 a1 4 :3 0 1 5 1 9 1 d 3 8 c 10 1 14 1 24 2 22 24 1 2f 1 39 2 3b 3c 2 21 3d 1 17 1 45 1 49 2 48 4c 1 56 1 5e 1 62 1 66 3 61 65 69 1 6d 1 7d 2 7b 7d 1 88 1 92 2 94 95 2 7a 96 1 70 1 9e 1 a2 1 a6 3 a1 a5 a9 1 ad 1 bd 2 bb bd 1 c8 1 d2 2 d4 d5 2 ba d6 1 b0 1 df 1 e3 2 e2 e6 1 ec 1 f3 1 f1 1 f8 1 106 1 10e 1 110 1 108 1 113 4 11b 11c 11d 11e 3 116 120 123 3 ef f6 fc 1 12b 1 12f 2 12e 132 1 13c 1 144 1 147 2 14e 152 7 42 5b 9b db 128 141 157 1 4 0 162 0 1 14 9 1e 0 1 1 1 1 1 6 1 1 0 0 0 0 0 0 0 0 0 0 0 4 1 2 de 1 6 9d 1 5 5d 1 4 44 1 3 143 1 9 f8 6 0 f1 6 0 ec 6 0 144 9 0 12b 8 0 df 6 0 9e 5 0 5e 4 0 45 3 0 5 2 0 12a 1 8 3 0 1 12f 8 0 e3 6 0 a2 5 0 62 4 0 49 3 0 9 2 0 a6 5 0 66 4 0 d 2 0 ad 5 0 6d 4 0 14 2 0 0 /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de