Oracle procedure encryption method, oracle encryption procedure

Oracle procedure encryption method, oracle encryption procedure

Oracle object Encryption Method

I. wrap Encryption

The following is a test procedure:

[Oracle @ orclrac1:/home/oracle] $ cat sp_test. SQL

Create or replace procedure leo (I in number)

As

Begin

Dbms_output.put_line ('input parameter: '| to_char (I ));

End;

The encryption process is as follows:

[Oracle @ orclrac1:/home/oracle] $ wrap iname = sp_test. SQL oname = sp_test_jm. SQL

PL/SQL Wrapper: Release 11.2.0.1.0-64bit Production on Wed Nov 08 14:06:58 2017

Copyright (c) 1993,200 9, Oracle. All rights reserved.

Processing sp_test. SQL to sp_test_jm. SQL

The following content is displayed after encryption is completed:

[Oracle @ orclrac1:/home/oracle] $ cat sp_test_jm. SQL

Create or replace procedure leo wrapped

A000000

354

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

7

6b AE

ELucoK2tPHT0oy + WjvSukeA9 + fUwg5nnm7 + fMr2ywFyFodexpcOl0l6lmYEywLIlXQbAdIsG

WMAy/tKGBgmm + x9jmo8wtvdiqvavmdd/gjSxz1pckfVFmLMFlpW8kcuYqFiwglpZCa9CNC/

M7h0JaV3d6CLBsCBx/vxdKa1unZI

/

Compile the stored procedure and execute it smoothly:

[Oracle @ orclrac1:/home/oracle] $ sqlplus zq/oracle

SQL * Plus: Release 11.2.0.1.0 Production on Wed Nov 8 14:07:03 2017

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> @ sp_test_jm. SQL

Procedure created.

SQL> set serveroutput on;

SQL> exec leo (100 );

Input parameter: 100

PL/SQL procedure successfully completed.

View the display in oracle Data Dictionary:

SQL> select name, text from user_source where type = 'processed' and name = 'Leo ';

NAME

----

TEXT

Certificate -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

LEO

Procedure leo wrapped

A000000

354

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

Abcd

7

6b AE

ELucoK2tPHT0oy + WjvSukeA9 + fUwg5nnm7 + fMr2ywFyFodexpcOl0l6lmYEywLIlXQbAdIsG

WMAy/tKGBgmm + x9jmo8wtvdiqvavmdd/gjSxz1pckfVFmLMFlpW8kcuYqFiwglpZCa9CNC/

M7h0JaV3d6CLBsCBx/vxdKa1unZI