Configuration environment:
1. Data Base: Oracle 8i R2 (8.1.7) for NT Enterprise Edition
2. installation path: C: ORACLE
Implementation Method:
1. D:> set NLS_LANG = AMERICAN_AMERICA.USACII7
Or
D:> set NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
D:> set
Run the set command to view environment variables.
2. Create a. SQL file under D: with the following content:
Java code
Create or replace procedure test1 (I in number)
Begin
Dbms_output.put_line ('input parameter is '| to_char (I ));
End;
Create or replace procedure test1 (I in number)
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,200 0. All Rights Reserved.
Processing a. SQL to a. plb
4. Open a. plb. Its content is as follows:
Java code
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:
1 NUMBER:
1DBMS_OUTPUT:
1PUT_LINE:
1. The input parameters are:
1 |:
1TO_CHAR:
0
0
0
1f
2
0 1d 9a 8f a0 b0 3d b4
55 6a: 2 a0 6b 6e 7e: 2 a0 a5
B b4 2e a5 57 b7 a4 b1
11 68 4f 17 b5
1f
2
0 3 4 1d 19 18 25 15
2a 2e 32 36 3a 3d 42 45
49 4d 4e 50 51 56 57 5c
5e 62 64 70 74 76 7f
1f
2
0 1 B 11 16: 2 11 10: 3 1
: 2 d 16 22 24 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
2 0 1
3 1 0
0
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:
1 NUMBER:
1DBMS_OUTPUT:
1PUT_LINE:
1. The input parameters are:
1 |:
1TO_CHAR:
0
0
0
1f
2
0 1d 9a 8f a0 b0 3d b4
55 6a: 2 a0 6b 6e 7e: 2 a0 a5
B b4 2e a5 57 b7 a4 b1
11 68 4f 17 b5
1f
2
0 3 4 1d 19 18 25 15
2a 2e 32 36 3a 3d 42 45
49 4d 4e 50 51 56 57 5c
5e 62 64 70 74 76 7f
1f
2
0 1 B 11 16: 2 11 10: 3 1
: 2 d 16 22 24 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
2 0 1
3 1 0
0
5. Run a. plb.
Java code
SQL> @ d: a. plb
SQL> @ d: a. plb
The process has been created.
6. Run the Stored Procedure
Java code
SQL> set serveroutput on
SQL> execute test1 (1 );
SQL> set serveroutput on
SQL> execute test1 (1 );
The input parameter is 1.
The PL/SQL process is successfully completed.
7. view the Stored Procedure Code
Java code
SQL> select name, text from all_source where type = 'processed' and name = 'test1 ';
SQL> select name, text from all_source where type = 'processed' and name = 'test1 ';
Result: the source code is not displayed.