Oracle encryption stored procedure operation notes

Create a stored procedure script file, such as test. SQL

Create or replace procedure DIS_1
As
I integer;
Begin
DBMS_OUTPUT.PUT_LINE ('Hello Beijing ');
End;
/

Note the last/Character

SQL> @ test. SQL
Procedure created.

SQL> set serveroutput on

SQL> exec DIS_1
Hello Beijing

PL/SQL procedure successfully completed.

SQL> select name, text from all_source where type = 'processed' and name = 'dis _ 1 ';

Then we can see that the text field named DIS_1 shows the plain text. Now we need to encrypt this text.

SQL> quit

$ Wrap iname = test. SQL

PL/SQL Wrapper: Release 9.2.0.8.0-64bit Production on Tue Aug 26 16:11:15 2008

Copyright (c) Oracle Corporation 1993,200 1. All Rights Reserved.

Processing test. SQL to test. plb

SQL> @ test. plb
Procedure created.

SQL> set serveroutput on

SQL> exec DIS_1
Hello Beijing

PL/SQL procedure successfully completed.

SQL> select name, text from all_source where type = 'processed' and name = 'dis _ 1 ';

The text field named DIS_1 shows the encrypted content.

Note: the steps in the encryption process are affected by the platform. That is to say, you cannot compile plb files on Windows platform into oracle on unix platform.