3 Replies Latest reply: Jun 16, 2011 10:26 AM by 869414 RSS

    Oracle Providers for ASP.NET issues - Experts Please help!!

    798077
      Hi All,
      I am using Oracle providers for Asp.net with my .Net web application. And using SQL Developer V 2.1.1.64 to execute all the sql scripts for creating membership objects.
      I am receiving following errors for certian functions "Error(1): PLS-00753: malformed or corrupted wrapped unit" when executed in SQl developer and when trying to compile it.

      Can anyone suggest me on how to fix this errors. Thanks in advance.

      One such function is as follows:

      create or replace
      FUNCTION "ORA_ASPNET_UIR_ADDUSERSTOROLES" wrapped
      0
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      abcd
      3
      8
      9200000
      1
      4
      0
      32
      2 :e:
      1FUNCTION:
      1ORA_ASPNET_UIR_ADDUSERSTOROLES:
      1APPLICATIONNAME_:
      1NVARCHAR2:
      1USERNAMES_:
      1ORA_ASPNET_ROLES_PKG:
      1ASSOCARRAYVARCHAR2_T:
      1USERNAMES_ARR_SIZE:
      1INTEGER:
      1ROLENAMES_:
      1ROLENAMES_ARR_SIZE:
      1USERNAME:
      1OUT:
      1ROLENAME:
      1RETURN:
      1OUTRESULT:
      1M_APPID:
      1RAW:
      116:
      1M_USERID:
      1M_ROLEID:
      1M_ROWSCHG:
      10:
      1APPLICATIONID:
      1ORA_ASPNET_APPLICATIONS:
      1LOWER:
      1LOWEREDAPPLICATIONNAME:
      1=:
      1NO_DATA_FOUND:
      1ROLE_NOT_FOUND:
      1I:
      11:
      1LOOP:
      1ROLEID:
      1ORA_ASPNET_ROLES:
      1LOWEREDROLENAME:
      1USERID:
      1ORA_ASPNET_USERS:
      1LOWEREDUSERNAME:
      1ISANONYMOUS:
      1LASTACTIVITYDATE:
      1SYS_EXTRACT_UTC:
      1SYSTIMESTAMP:
      1J:
      1K:
      1ORA_ASPNET_USERSINROLES:
      1UNIQUE_CONSTRAINT_VIOLATED:
      1ROLLBACK:
      1ROLLBACK_NR:
      1THIS_USER_ALREADY_IN_ROLE:
      0

      0
      0
      181
      2
      0 a0 8d 8f a0 b0 3d 8f
      :2 a0 6b b0 3d 8f a0 b0 3d
      8f :2 a0 6b b0 3d 8f a0 b0
      3d 96 :2 a0 b0 54 96 :2 a0 b0
      54 b4 :2 a0 2c 6a a3 a0 1c
      81 b0 a3 a0 51 a5 1c 4d
      81 b0 a3 a0 51 a5 1c 4d
      81 b0 a3 a0 51 a5 1c 4d
      81 b0 a3 a0 1c 51 81 b0
      a0 ac :2 a0 b2 ee :2 a0 a5 b
      a0 7e b4 2e ac e5 d0 b2
      e9 b7 :4 a0 6b 65 b7 a6 9
      a4 b1 11 4f 91 51 :2 a0 63
      37 a0 ac :2 a0 b2 ee :3 a0 a5
      b a5 b a0 7e b4 2e :2 a0
      7e b4 2e a 10 ac e5 d0
      b2 e9 b7 :4 a0 a5 b d :3 a0
      6b 65 b7 a6 9 a4 b1 11
      4f b7 a0 47 91 51 :2 a0 63
      37 a0 ac :2 a0 b2 ee :2 a0 7e
      :2 a0 a5 b a5 b b4 2e :2 a0
      7e b4 2e a 10 ac e5 d0
      b2 e9 b7 :a a0 a5 b :3 a0 a5
      b a5 b 51 :2 a0 a5 b 5
      d7 b2 5 e9 b7 a6 9 a4
      b1 11 4f b7 a0 47 b7 a4
      b1 11 4f a0 4d d a0 4d
      d 91 51 :2 a0 63 37 a0 ac
      :2 a0 b2 ee :2 a0 7e :2 a0 a5 b
      a5 b b4 2e :2 a0 7e b4 2e
      a 10 ac e5 d0 b2 e9 91
      51 :2 a0 63 37 a0 ac :2 a0 b2
      ee :3 a0 a5 b a5 b a0 7e
      b4 2e :2 a0 7e b4 2e a 10
      ac e5 d0 b2 e9 :5 a0 5 d7
      b2 5 e9 b7 :2 a0 6b a0 57
      a0 b4 e9 :3 a0 a5 b d :3 a0
      a5 b d :3 a0 6b 65 b7 a6
      9 a4 b1 11 4f b7 a0 47
      b7 a0 47 a0 51 65 b7 a4
      b1 11 68 4f 1d 17 b5
      181
      2
      0 3 7 23 1f 1e 2b 3c
      34 38 1b 33 44 51 4d 30
      59 69 5e 62 66 4c 71 7e
      7a 49 86 93 8b 8f 79 9a
      ab a3 a7 76 b2 a2 b7 bb
      bf c3 dc cb cf d7 9f f9
      e3 e7 ea eb f3 f4 ca 117
      104 c7 108 109 111 112 103 135
      122 100 126 127 12f 130 121 151
      140 144 11e 14c 13f 158 13c 15c
      160 164 165 16c 170 174 175 177
      17b 17e 17f 184 185 18b 18f 190
      195 197 19b 19f 1a3 1a7 1aa 1ae
      1b0 1b1 1b6 1ba 1bc 1c8 1ca 1ce
      1d1 1d5 1d9 1dd 1df 1e3 1e4 1e8
      1ec 1ed 1f4 1f8 1fc 200 201 203
      204 206 20a 20d 20e 213 217 21b
      21e 21f 1 224 229 22a 230 234
      235 23a 23c 240 244 248 24c 24d
      24f 253 257 25b 25f 262 266 268
      269 26e 272 274 280 282 284 288
      28f 293 296 29a 29e 2a2 2a4 2a8
      2a9 2ad 2b1 2b2 2b9 2bd 2c1 2c4
      2c8 2cc 2cd 2cf 2d0 2d2 2d3 2d8
      2dc 2e0 2e3 2e4 1 2e9 2ee 2ef
      2f5 2f9 2fa 2ff 301 305 309 30d
      311 315 319 31d 321 325 329 32a
      32c 330 334 338 339 33b 33c 33e
      341 345 349 34a 34c 350 358 359
      35d 362 364 365 36a 36e 370 37c
      37e 380 384 38b 38d 391 393 39f
      3a1 3a5 3a6 3aa 3ae 3af 3b3 3b7
      3ba 3be 3c2 3c6 3c8 3cc 3cd 3d1
      3d5 3d6 3dd 3e1 3e5 3e8 3ec 3f0
      3f1 3f3 3f4 3f6 3f7 3fc 400 404
      407 408 1 40d 412 413 419 41d
      41e 423 427 42a 42e 432 436 438
      43c 43d 441 445 446 44d 451 455
      459 45a 45c 45d 45f 463 466 467
      46c 470 474 477 478 1 47d 482
      483 489 48d 48e 493 497 49b 49f
      4a3 4a7 4ab 4b3 4b4 4b8 4bd 4bf
      4c3 4c7 4ca 4ce 4d3 4d7 4d8 4dd
      4e1 4e5 4e9 4ea 4ec 4f0 4f4 4f8
      4fc 4fd 4ff 503 507 50b 50f 512
      516 518 519 51e 522 524 530 532
      534 538 53f 541 545 54c 550 553
      557 559 55d 55f 56b 56f 571 572
      57b
      181
      2
      0 1 a 3 1d :3 3 17 2c
      17 :3 3 20 :3 3 12 27 12 :3 3
      20 :3 3 d 11 :3 3 d 11 :2 3
      :2 1 8 :2 1 3 :3 e :2 3 c 10
      f c 17 c :2 3 d 11 10
      d 18 d :2 3 d 11 10 d
      18 d :2 3 :2 e 19 e 3 :2 9
      1c 29 24 29 b 11 :2 b 25
      :3 23 24 :4 2 1 8 4 b :2 20
      4 16 :2 3 2 :3 1 6 b e
      21 b 2 :2 b 17 25 20 25
      c 12 1d :2 12 :2 c 23 :3 21 37
      47 :3 45 :2 c 20 :4 4 3 b 8
      14 1f :2 14 :2 8 f :2 24 8 19
      :2 6 4 :4 21 6 2 6 b e
      21 b 2 :2 b 17 b 6 b
      e 20 1e 26 31 :2 26 :2 20 :2 1e
      39 49 :3 47 :2 e 6 :4 4 3 a
      14 26 35 3f 50 5d c 15
      20 :2 15 24 2a 35 :2 2a :2 24 3a
      3d 4d :2 3d b :4 8 18 :2 5 4
      :4 21 6 2 :6 1 d :2 1 d


      1
      5 a d 20 a 1 :2 a 16
      a 5 a d 1f 1d 25 30
      :2 25 :2 1f :2 1d 38 48 :3 46 :2 d 5
      :4 3 7 c f 22 c 3 :2 c
      18 26 21 26 e 14 1f :2 14
      :2 e 25 :3 23 39 49 :3 47 :2 e 21
      :4 5 12 2b 33 9 13 8 :4 6
      5 c 21 c :6 9 15 20 :2 15
      :2 9 15 20 :2 15 :2 9 10 :2 25 9
      3c :2 7 6 :4 22 7 3 20 5
      1 3 a 3 :9 1
      181
      4
      0 :2 1 :4 3 :6 4
      :4 5 :6 6 :4 7 :5 8
      :5 9 2 :2 c :2 1
      :5 d :8 e :8 f :8 10
      :6 11 :6 15 :8 16 :5 15
      14 19 :5 1a :3 19
      18 :3 12 :6 25 :6 28
      :12 29 :5 28 27 2c
      :6 2d :5 2e :3 2c 2b
      :4 25 31 25 :6 37
      :3 3a :3 3b :12 3c 3b
      :4 3a 39 3f :6 41
      :12 42 :4 41 :3 3f 3e
      :4 37 45 37 :2 35
      :3 12 :3 4c :3 4d :6 4f
      :3 51 :3 52 :12 53 52
      :4 51 :6 55 :6 57 :12 58
      :5 57 :3 5b :3 5c :4 5b
      5a :3 5f :5 60 :6 61
      :6 62 :5 63 :3 5f 5e
      :4 55 66 55 4f
      68 4f :3 6c :2 12
      :7 1
      57d
      4
      :3 0 1 :3 0 2
      :a 0 17c 1 :7 0
      8 9 0 3
      4 :3 0 3 :7 0
      5 4 :3 0 7
      49 0 5 6
      :3 0 7 :2 0 4
      5 :7 0 b a
      :3 0 b 76 0
      :2 9 :3 0 8 :7 0
      f e :3 0 6
      :3 0 7 :2 0 4
      12 13 0 a
      :7 0 15 14 :3 0
      f 9f 0 d
      9 :3 0 b :7 0
      19 18 :3 0 d
      :3 0 4 :3 0 c
      :6 0 1e 1d :3 0
      19 c7 0 11
      d :3 0 4 :3 0
      e :6 0 23 22
      :3 0 f :3 0 9
      :3 0 25 27 0
      17c 2 28 :2 0
      13 :2 0 1d 9
      :3 0 2b :7 0 2e
      2c 0 17a 0
      10 :6 0 12 :3 0
      13 :2 0 1b 30
      32 :7 0 36 33
      34 17a 0 11
      :6 0 13 :2 0 21
      12 :3 0 1f 38
      3a :7 0 3e 3b
      3c 17a 0 14
      :6 0 17 :2 0 25
      12 :3 0 23 40
      42 :7 0 46 43
      44 17a 0 15
      :6 0 29 :2 0 27
      9 :3 0 48 :7 0
      4c 49 4a 17a
      0 16 :6 0 18
      :3 0 11 :3 0 19
      :3 0 2b 51 5a
      0 5b :3 0 1a
      :3 0 3 :3 0 2d
      53 55 1b :3 0
      1c :2 0 31 58
      59 :4 0 5d 5e
      :5 0 4e 52 0
      34 0 5c :2 0
      60 36 6c 1d
      :3 0 f :3 0 6
      :3 0 1e :3 0 63
      64 0 65 :2 0
      67 38 69 3a
      68 67 :2 0 6a
      3c :2 0 6c 0
      6c 6b 60 6a
      :6 0 178 1 :3 0
      1f :3 0 20 :2 0
      b :3 0 21 :3 0
      6f 70 :2 0 6e
      72 22 :3 0 3e
      15 :3 0 23 :3 0
      40 78 8b 0
      8c :3 0 1a :3 0
      a :3 0 1f :3 0
      42 7b 7d 44
      7a 7f 24 :3 0
      1c :2 0 48 82
      83 :3 0 18 :3 0
      11 :3 0 1c :2 0
      4d 87 88 :3 0
      84 8a 89 :3 0
      8e 8f :5 0 75
      79 0 50 0
      8d :2 0 91 52
      a3 1d :3 0 e
      :3 0 a :3 0 1f
      :3 0 54 94 96
      93 97 0 9e
      f :3 0 6 :3 0
      1e :3 0 9a 9b
      0 9c :2 0 9e
      56 a0 59 9f
      9e :2 0 a1 5b
      :2 0 a3 0 a3
      a2 91 a1 :6 0
      a5 3 :3 0 5d
      a7 21 :3 0 73
      a5 :4 0 178 1f
      :3 0 20 :2 0 8
      :3 0 21 :3 0 a9
      aa :2 0 a8 ac
      25 :3 0 5f 14
      :3 0 26 :3 0 61
      b2 c5 0 c6
      :3 0 27 :3 0 1a
      :3 0 1c :2 0 5
      :3 0 1f :3 0 63
      b7 b9 65 b5
      bb 69 b6 bd
      :3 0 18 :3 0 11
      :3 0 1c :2 0 6e
      c1 c2 :3 0 be
      c4 c3 :3 0 c8
      c9 :5 0 af b3
      0 71 0 c7
      :2 0 cb 73 ee
      1d :3 0 26 :3 0
      18 :3 0 c :3 0
      27 :3 0 28 :3 0
      29 :3 0 11 :3 0
      5 :3 0 1f :3 0
      75 d4 d6 1a
      :3 0 5 :3 0 1f
      :3 0 77 d9 db
      79 d8 dd 17
      :2 0 2a :3 0 2b
      :3 0 7b e0 e2
      7d :3 0 cd e6
      e7 e8 :4 0 83
      89 :4 0 e5 :2 0
      e9 8b eb 8d
      ea e9 :2 0 ec
      8f :2 0 ee 0
      ee ed cb ec
      :6 0 f0 6 :3 0
      91 f2 21 :3 0
      ad f0 :4 0 f3
      93 f6 :3 0 f6
      0 f6 f5 f3
      f4 :6 0 178 1
      :3 0 14 :4 0 f8
      f9 0 178 15
      :4 0 fb fc 0
      178 2c :3 0 20
      :2 0 8 :3 0 21
      :3 0 ff 100 :2 0
      fe 102 25 :3 0
      95 14 :3 0 26
      :3 0 97 108 11b
      0 11c :3 0 27
      :3 0 1a :3 0 1c
      :2 0 5 :3 0 2c
      :3 0 99 10d 10f
      9b 10b 111 9f
      10c 113 :3 0 18
      :3 0 11 :3 0 1c
      :2 0 a4 117 118
      :3 0 114 11a 119
      :3 0 11e 11f :5 0
      105 109 0 a7
      0 11d :2 0 172
      2d :3 0 20 :2 0
      b :3 0 21 :3 0
      122 123 :2 0 121
      125 22 :3 0 a9
      15 :3 0 23 :3 0
      ab 12b 13e 0
      13f :3 0 1a :3 0
      a :3 0 2d :3 0
      ad 12e 130 af
      12d 132 24 :3 0
      1c :2 0 b3 135
      136 :3 0 18 :3 0
      11 :3 0 1c :2 0
      b8 13a 13b :3 0
      137 13d 13c :3 0
      141 142 :5 0 128
      12c 0 bb 0
      140 :2 0 16f 2e
      :3 0 25 :3 0 22
      :3 0 14 :3 0 15
      :3 0 bd :3 0 144
      14b 14c 14d :4 0
      c0 c3 :4 0 14a
      :2 0 14e c5 16d
      6 :3 0 2f :2 0
      4 14f 150 0
      30 :3 0 154 155
      :2 0 156 31 :2 0
      80 :2 0 153 :2 0
      168 e :3 0 a
      :3 0 2d :3 0 c7
      158 15a 157 15b
      0 168 c :3 0
      5 :3 0 2c :3 0
      c9 15e 160 15d
      161 0 168 f
      :3 0 6 :3 0 32
      :3 0 164 165 0
      166 :2 0 168 cb
      16a d0 169 168
      :2 0 16b d2 :2 0
      16d 0 16d 16c
      14e 16b :6 0 16f
      9 :3 0 d4 171
      21 :3 0 126 16f
      :4 0 172 d7 174
      21 :3 0 103 172
      :4 0 178 f :3 0
      17 :2 0 176 :2 0
      178 da 17b :3 0
      17b e2 17b 17a
      178 179 :6 0 17c
      :2 0 2 28 17b
      17f :3 0 17e 17c
      180 :8 0
      e8
      4
      :3 0 1 3 1
      7 1 d 1
      11 1 17 1
      1b 1 20 7
      6 c 10 16
      1a 1f 24 1
      2a 1 31 1
      2f 1 39 1
      37 1 41 1
      3f 1 47 1
      4d 1 50 1
      54 1 57 2
      56 57 1 4f
      1 5f 1 66
      1 61 1 69
      1 74 1 77
      1 7c 1 7e
      1 81 2 80
      81 1 86 2
      85 86 1 76
      1
      9
      0
      1 95
      2 98 9d 1
      92 1 a0 1
      a3 1 ae 1
      b1 1 b8 1
      ba 1 bc 2
      b4 bc 1 c0
      2 bf c0 1
      b0 1 ca 1
      d5 1 da 1
      dc 1 e1 5
      d3 d7 de df
      e3 5 ce cf
      d0 d1 d2 1
      e4 1 e8 1
      cc 1 eb 1
      ee 1 f2 1
      104 1 107 1
      10e 1 110 1
      112 2 10a 112
      1 116 2 115
      116 1 106 1
      127 1 12a 1
      12f 1 131 1
      134 2 133 134
      1 139 2 138
      139 1 129 2
      147 148 2 145
      146 1 149 1
      14d 1 159 1
      15f 4 156 15c
      162 167 1 151
      1 16a 2 143
      16d 2 120 171
      7 6c a7 f6
      fa fd 174 177
      5 2d 35 3d
      45 4b
      1
      4
      0
      17f
      0
      1
      14
      a
      11
      0 1 1 3 1 5 6 1
      8 9 0 0 0 0 0 0
      0 0 0 0
      17 1 0
      1b 1 0
      3f 1 0
      7 1 0
      11 1 0
      2a 1 0
      a8 6 0
      6e 3 0
      2 0 1
      fe 8 0
      121 9 0
      37 1 0
      2f 1 0
      47 1 0
      d 1 0
      20 1 0
      3 1 0
      0
      /

      Edited by: user13395686 on 15-Sep-2010 1:27 PM

      EDIT: Same sql code is working on Windows 7 - 32 bit machine but not working on Windows 7- 64 bit machine. I am using Oracle database 10g Express Edition

      Edited by: user13395686 on 15-Sep-2010 1:29 PM

      Edited by: user13395686 on 15-Sep-2010 1:49 PM