D:>set Nls_lang=american_america. We8iso8859p1
D:>set
Direct SET command to view environment variables
2,
Under D: Create the A.sql file, which reads as follows:
Create or Replace procedure test1 (i in number) as
Begin
Dbms_output.put_line (' input parameter is ' | | To_char (i));
End
3,
D:>wrap Iname=a.sql
Pl/sql wrapper:release 8.1.7.0.0-production on Tue Nov 27 22:26:48 2001
Copyright (c) Oracle Corporation 1993, 2000. All Rights Reserved.
Processing A.sql to A.PLB
4,
Open A.PLB, now its contents are as follows:
Create or replace procedure test1 wrapped
0
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
Abcd
3
7
8106000
1
4
0
8
2:e:
1test1:
1I:
1NUMBER:
1dbms_output:
1put_line:
1 Input parameters are:
1| |:
1to_char:
0
0
0
1f
2
0 1d 9a 8f a0 B0 3d B4
6a:2 A0 6b 6e 7e:2 A0 A5
b B4 2e a5 b7 a4 B1
4f B5
1f
2
0 3 4 1d 19 18 25 15
2a 2e 3a 3d 42 45
4d 4e 5c
5e, 7f
1f
2
0 1 B 11 16:2 11 10:3 1
: 2 D 2c:2 24:2 16:a 1
1f
2
0:9 1:d 3:2 2:3 1 4:2 1
81
4
: 4 0 1:A 0 1b
1:4 0 5:2 0
: 2 3:3 0 2:7 0
5 4:3 0 7
: 2 0 1b 2 8
: 2 0 4:3 0 5
: 3 0 A B 0
6:4 0 7:2 0
8:3 0 2:3 0
7 F 11 9
e 13:3 0:2 C
15:2 0 17 10
1a:3 0 1a 0
1a 19 17 18
: 6 0 1b:2 0 2
8 1a 1d:2 0
1 1b 1e:8 0
13
4
: 3 0 1 3 1
6 1 10 2
D 12 1 14
1 16 2 16
1c
1
4
0
1d
0
1
14
1
2
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0
2 0 1
3 1 0
0
/
5. Operation A.PLB
Sql> @d:a.plb
Procedure has been created.
6. Run the stored procedure
Sql> set Serveroutput on
Sql> execute test1 (1);
Input parameter is 1
The PL/SQL process has completed successfully.
7, view the code of the stored procedure
Sql> Select Name,text from All_source where type= ' PROCEDURE ' and name= ' TEST1 ';
Result: Cannot see its original code