--测试的存储过程
CREATE OR REPLACE PROCEDURE P_PROCEDURE_TEST AS
BEGIN
NULL;
END;
保存到 D:\P_procedure_test.sql
--切换到操作系统命令行,本例子是在windows上操作,也可以linux上操作存储过程加密
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>d:
D:\>wrap iname=D:\P_procedure_test.sql
PL/SQL Wrapper: Release 11.1.0.6.0- Production on 星期二 6月 12 13:42:10 2012
Copyright (c) 1993, 2004, Oracle. All rights reserved.
Processing D:\P_procedure_test.sql to P_procedure_test.plb
D:\>sqlplus financeteam/fateam132@p20
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 6月 12 13:43:11 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @D:\P_procedure_test.plb;
过程已创建。
CREATE OR REPLACE PROCEDURE P_PROCEDURE_TEST AS
BEGIN
NULL;
END;
保存到 D:\P_procedure_test.sql
--切换到操作系统命令行,本例子是在windows上操作,也可以linux上操作存储过程加密
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>d:
D:\>wrap iname=D:\P_procedure_test.sql
PL/SQL Wrapper: Release 11.1.0.6.0- Production on 星期二 6月 12 13:42:10 2012
Copyright (c) 1993, 2004, Oracle. All rights reserved.
Processing D:\P_procedure_test.sql to P_procedure_test.plb
D:\>sqlplus financeteam/fateam132@p20
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 6月 12 13:43:11 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @D:\P_procedure_test.plb;
过程已创建。