使用Oracle Wrap加密代码

 1.源代码
createorreplacefunctionget_rowid
(l_rowidinvarchar2)
returnvarchar2
is
ls_my_rowidvarchar2(200);
rowid_typenumber;
object_numbernumber;
relative_fnonumber;
block_numbernumber;
row_numbernumber;
begin
dbms_rowid.rowid_info(l_rowid,rowid_type,object_number,relative_fno,block_number,row_number);
ls_my_rowid:=Object#is:||to_char(object_number)||chr(10)||
Relative_fnois:||to_char(relative_fno)||chr(10)||
Blocknumberis:||to_char(block_number)||chr(10)||
Rownumberis:||to_char(row_number);
returnls_my_rowid;
end;
/





2.代码功能测试

[oracle@jumpertools]$sqlplusscott/tiger

SQL*Plus:Release9.2.0.4.0-ProductiononMonNov1521:56:362004

Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.


Connectedto:
Oracle9iEnterpriseEditionRelease9.2.0.4.0-Production
WiththePartitioningoption
JServerRelease9.2.0.4.0-Production

SQL>@f_get_rowid

Functioncreated.

SQL>selectrowidfromdeptwheredeptno=10;

ROWID
------------------
AAABiPAABAAAFRSAAA

SQL>selectget_rowid(AAABiPAABAAAFRSAAA)fromdual;

GET_ROWID(AAABIPAABAAAFRSAAA)
------------------------------------------------------------------
Object#is:6287
Relative_fnois:1
Blocknumberis:21586
Rownumberis:0


SQL>!
[oracle@jumpertools]$ls
ct.sqlddlt.sqlf_get_rowid.sqlgetevent.sql


3.使用wrap加密及加密后的代码

[oracle@jumpertools]$wrapiname=f_get_rowid.sqloname=f_get_rowid.plb

PL/SQLWrapper:Release9.2.0.4.0-ProductiononMonNov1521:59:392004

Copyright(c)OracleCorporation1993,2001.AllRightsReserved.

Processingf_get_rowid.sqltof_get_rowid.plb

[oracle@jumpertools]$catf_get_rowid.plb
createorreplacefunctionget_rowidwrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
8
9200000
1
4
0
17
2:e:
1FUNCTION:
1GET_ROWID:
1L_ROWID:
1VARCHAR2:
1RETURN:
1LS_MY_ROWID:
1200:
1ROWID_TYPE:
1NUMBER:
1OBJECT_NUMBER:
1RELATIVE_FNO:
1BLOCK_NUMBER:
1ROW_NUMBER:
1DBMS_ROWID:
1ROWID_INFO:
1Object#is:::
1||:
1TO_CHAR:
1CHR:
110:
1Relative_fnois:::
1Blocknumberis:::
1Rownumberis:::
0

0
0
83
2
0a08d8fa0b03db4
:2a02c6aa3a051a51c
81b0a3a01c81b0a3
a01c81b0a3a01c81
b0a3a01c81b0a3a0
1c81b0:2a06b:6a0a557
a06e7e:2a0a5bb42e

 

673d6469
:3011:2017
:40406b6d
:3011:2012
:30d:3043
7072456f
74:303775
07a5:30
6:3078:20
7a487d:30
7d4c7d7c
7a7b:607e
:202a7d
81:30807e
82:80
53
4
:30131
61e1
c1131
1811d1
221276
2f303132
333413b
2383d1
4223f44
246481
4d24a4f
154251
562585a
15f25c
611662
636826a
6c1712
6e73336
7679611
161b2025
2a
1
4
0
81
0
1
14
1
8
00000000
00000000
0000
310
2210
201
c10
1310
2710
1810
1d10
0

/


4.测试加密后的代码

[oracle@jumpertools]$exit
exit

SQL>dropfunctionget_rowid;

Functiondropped.

SQL>@f_get_rowid.plb

Functioncreated.

SQL>selectget_rowid(AAABiPAABAAAFRSAAA)fromdual;

GET_ROWID(AAABIPAABAAAFRSAAA)
-----------------------------------------------------------------
Object#is:6287
Relative_fnois:1
Blocknumberis:21586
Rownumberis:0


SQL>

 

7ea051a5bb42e7e
6eb42e7e:2a0a5bb4
2e7ea051a5bb42e
7e6eb42e7e:2a0a5b
b42e7ea051a5bb4
2e7e6eb42e7e:2a0a5
bb42ed:2a065b7a4
b111684f1d17b5
83
2
037231f1e2b1b
3034383c5944484b
4c54437564687040
8d7c808863a9989c
a460c1b0b4bc97dd
ccd0d894c8e4e8eb
eff3f7fbff103104109
10d11211511911d11e120121
12612912d130131133134139
13c14114214714a14e152153
15515615b15e162165166168
16916e17117617717c17f183
18718818a18b19019319719a
19b19d19e1a31a61ab1ac1b1
1b41b81bc1bd1bf1c01c51c9
1cd1d11d51d71db1dd1e91ed
1ef1f01f9
83
2
01a2d:22:218
:31e1716:2e:21:3d:21
:310:21:3f:21:3f:21:3d1
2:2d18202b394755
:321124262e:226:2113c
3e42:23e:211453:21116
1820:218:2112d2f33:22f
:211363:211161820:218
:2112d2f33:22f:211363
:211161820:218:211:229
2:91
83
4
0:21:52:23
:21:75:56:57
:58:59:5a:bc
:11de:2d:5e
:2d:5e:2de
f:2d:5f:2d
:5f:2df10
:2d:510:3d:311
:2b:71
1fb
4
:301:302
:a07e1:70
5:2034
:303:705
4:305:30
4:3079
07e2a
:20b600
94:307
:207df
:6012100
7c06:60
f940d
9:3014:70
171507c
08:609
:3019:701c
1a07c0
a:6013c8
0119:30
1e:70211f
07c0b
:609:3023
:7026240
7c0c:60
e:309:30
28:702b29
07c0d
:60f:302c
2d03:30
8:30a:30
b:30c:30
d:30152e
35:207a6
:3010:4011
:2012:30a
:301c3a3c
1e393e:30
11:2013:30
14:202141
43234045
:3011:2015
:40264749
:3011:2012
:30b:3029
4c4e2b4b
50:3011:20
13:3014:20
2e535530
5257:3011
:2016:4033
595b:3011
:2012:30c
:30365e60
385d62:30
11:2013:30
14:203b65

程序员特区

http://coderarea.net/html/shujukukaifa/Oracle/2009/0311/60158.html