Important Announcement
This forum will be discontinued.
The creation of new topics is disabled.
Please open GitHub issues for the corresponding topics/products in the following Trivadis repositories:
- PL/SQL & SQL Coding Guidelines
- PL/SQL Cop Command Line
- PL/SQL Cop for SonarQube
- PL/SQL Cop for SQL Developer
- PL/SQL Cop Validators
- PL/SQL Analyzer
- PL/SQL Unwrapper
A lot of users have already a GitHub account and the management of the issues is better than in this forum. For example, closing a forum topic is never related to a product change. Closing a GitHub issue for an accepted bug means that the bug is fixed. This should simplify the work for all involved parties.
See this blog post for more information.
Thank you for your understanding.
hi getting this error when trying to run the unwrap.
"Could not unwrap this code. Most probably it was not wrapped with the Oracle 10g, 11g or 12c wrap utility."
Any suggestions how to get around this?
I assume that the error message is correct and the coded has been wrapped with a pre Oracle 10g wrap utility. See also FAQ Is unwrapping code processed by the PL/SQL Wrapper of Oracle7, Oracle8, Oracle8i or Oracle9i supported?
Please post the wrapped code, if you think the code has been wrapped with an Oracle 10g or newer wrap utility.
Was unable to wrap function below with error 20>0 unwrap failed
create or replace FUNCTION "MYPROC" wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
8003000
1
4
0
20
8 FUNCTION:
8 DEC_TEXT:
d PASSWORD_TEXT:
8 VARCHAR2:
6 RETURN:
a KEY_STRING:
2 20:
13 VARCHAR2_RAW_FILLER:
7 RAW_KEY:
3 RAW:
3 128:
7 UTL_RAW:
b CAST_TO_RAW:
9 RAW_INPUT:
3 256:
d DECRYPTED_RAW:
4 2048:
15 DECRYPTED_STRING_PLUS:
10 DECRYPTED_STRING:
7 IS NULL:
3 NOT:
8 HEXTORAW:
18 DBMS_OBFUSCATION_TOOLKIT:
a DESDECRYPT:
5 INPUT:
3 KEY:
e DECRYPTED_DATA:
10 CAST_TO_VARCHAR2:
7 REPLACE:
3 CHR:
3 171:
0 0
0
0
82
2
0 a0 1d 8d 8f a0 b0 3d
b4 :2 a0 a3 2c 6a a0 51 a5
1c 6e 81 b0 a3 a0 51 a5
1c :2 a0 6b a0 a5 b 81 b0
a3 a0 51 a5 1c 81 b0 a3
a0 51 a5 1c 81 b0 a3 a0
51 a5 1c 81 b0 a3 a0 51
a5 1c 81 b0 a0 7e b4 2e
5a 7e b4 2e :3 a0 a5 b d
:2 a0 6b :2 a0 e :2 a0 e :2 a0 e
a5 57 :3 a0 6b a0 a5 b d
:4 a0 51 a5 b a5 b d :2 a0
5a 65 b7 a0 6e 5a 65 b7
:2 19 3c b7 a4 a0 b1 11 68
4f 17 b5
82
2
0 3 7 8 20 1c 1b 28
1a 2d 31 5a 39 3d 41 45
48 49 51 56 38 86 65 35
69 6a 72 76 7a 7d 81 18
82 64 a2 91 61 95 96 9e
90 be ad 8d b1 b2 ba ac
da c9 a9 cd ce d6 c8 f6
e5 c5 e9 ea f2 e4 fd e1
101 102 107 10a 10d 10e 113 117
11b 11f 120 122 126 12a 12e 131
135 139 13b 13f 143 145 149 14d
14f 150 155 159 15d 161 164 168
169 16b 16f 173 177 17b 17f 182
183 185 186 188 18c 190 194 197
19b 19d 1a1 1a6 1a9 1ad 1af 1b3
1b7 1ba 1bc 1c0 1c4 1c6 1d1 1d5
1d7 1de
82
2
0 :2 1 a 13 24 :2 13 12 1
8 :3 1 c 15 14 c 1c c
:2 1 9 d c 9 15 :2 1d 29
:2 15 9 :2 1 b f e :2 b :2 1
f 13 12 :2 f :2 1 17 20 1f
:2 17 :2 1 12 1b 1a :2 12 1 :4 9
8 :3 4 3 14 1d :2 14 :2 3 :2 1c
27 30 27 3f 46 3f 4f 61
4f :3 3 1c :2 24 35 :2 1c :2 3 17
1f 35 39 :2 35 :2 17 :2 3 b a
3 20 3 b a 3 :6 1 5
:6 1
82
2
0 :8 1 :2 2 3 :2 1 :7 3 :d 4 :7 5
:7 7 :7 8 :7 9 :8 c :6 d :e f :8 11 :a 12
:4 14 c :4 16 :2 15 :2 c :2 a 18 :6 1
1e0
2
:3 0 1 :4 0 2 :a 0 7e 1 :3 0
1c 1e 5 3 4 :3 0 3 :7 0
6 5 :3 0 5 :3 0 4 :3 0 b
:2 0 9 8 a 0 7e 3 c
:2 0 4 :3 0 7 :2 0 7 e 10
:6 0 8 :4 0 14 11 12 7c 6
:6 0 f :2 0 f a :3 0 b 16
18 :6 0 c :3 0 d :3 0 1a 1b
0 6 :3 0 d 21 19 1f 7c
9 :6 0 11 :2 0 13 a :3 0 11
23 25 :6 0 28 26 0 7c e
:6 0 11 :2 0 17 a :3 0 15 2a
2c :6 0 2f 2d 0 7c 10 :6 0
11 :2 0 1b 4 :3 0 19 31 33
:6 0 36 34 0 7c 12 :6 0 14
:2 0 1f 4 :3 0 1d 38 3a :6 0
3d 3b 0 7c 13 :6 0 3 :3 0
21 3f 40 :3 0 41 :2 0 15 :2 0
23 43 44 :3 0 10 :3 0 16 :3 0
3 :3 0 25 47 49 46 4a 0
70 17 :3 0 18 :3 0 4c 4d 0
19 :3 0 10 :3 0 4f 50 1a :3 0
9 :3 0 52 53 1b :3 0 10 :3 0
55 56 27 4e 58 :2 0 70 12
:3 0 c :3 0 1c :3 0 5b 5c 0
10 :3 0 2b 5d 5f 5a 60 0
70 13 :3 0 1d :3 0 12 :3 0 1e
:3 0 1f :2 0 2d 65 67 2f 63
69 62 6a 0 70 5 :3 0 13
:3 0 6d :2 0 6e :2 0 70 32 77
5 :3 0 20 :4 0 72 :2 0 73 :2 0
75 38 76 0 75 0 78 45
70 0 78 3a 0 79 3d 7d
:3 0 7d 2 :3 0 3f 7d 7c 79
7a :6 0 7e 0 3 c 7d 80
:2 0 2 7e 81 :6 0
46
2
:3 0 1 4 1 7 1 f 1
b 1 17 1 1d 1 15 1
24 1 22 1 2b 1 29 1
32 1 30 1 39 1 37 1
3e 1 42 1 48 3 51 54
57 1 5e 1 66 2 64 68
5 4b 59 61 6b 6f 1 74
2 77 76 1 78 6 13 20
27 2e 35 3c
1
4
0
80
0
1
14
1
8
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0
15 1 0
b 1 0
4 1 0
29 1 0
30 1 0
37 1 0
22 1 0
3 0 1
0
This package is wrapped in an old format. This is not supported by PL/SQL Unwrapper as explained above.