How to encrypt stored procedures in Oracle

Source: Network/Editor: getting started with programming: Unknown

Software environment:

1. Operating System: Windows 2000 Server

2. Data Base: Oracle 8i R2 (8.1.7) for NT Enterprise Edition

3. 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:. The content is as follows:

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 and its content is 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:
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.

　　SQL> @d:a.plb

The process has been created.

6. Run the Stored Procedure

　　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

　　SQL> select name,text from all_source where type='PROCEDURE' and name='TEST1';

Result: The original code is not displayed.