Oracle加密存储过程操作笔记

创建存储过程脚本文件，如 test.sql

create or replace procedure DIS_1
as
 i integer;
begin
 DBMS_OUTPUT.PUT_LINE('Hello Beijing');
end;
/

注意最后的/字符

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='PROCEDURE' and name='DIS_1';

这时会看到过程名为DIS_1的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, 2001.  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='PROCEDURE' and name='DIS_1';

这时会看到过程名为DIS_1的text字段显示了加密后的内容。

注：加密过程的步骤受平台的影响，也就是说不能把win平台上的plb文件编译到unix平台上的oracle中去。