取消包装Oracle软件包 [英] Un Wrap Oracle Package

问题描述

我需要解开由其他一些开发人员创建的Oracle软件包. 我在数据库中创建了Prackage，但是使用了加密格式.

I need to un wrap an Oracle Package created by some other dev. I have the Prackage created in my DB, but in encrypted format.

我需要的原因是，原始开发人员已离开组织，现在需要使用DB结构和逻辑的更新更改重新定义程序包中定义的过程.

The reason i need is, original Developer has left the organization and now the procedure define in the package needs to be redefine with updated changes in DB Structure and logic.

有人可以为我提供帮助吗，我该如何将包装解包到oracle中.

Can some one help me as How can i un wrap the package in oracle.

推荐答案

您可以在此处粘贴代码，它将为您打开包装.
建议您将丢失所有注释，但变量名称将保留.
但是为了好玩，让我们测试一下逻辑.

You can paste the code here and it will unwrap it for you.
Be advised you will lose all comments but variable names will remain.
But for fun lets test the logic.

首先创建过程:

sqlplus testing/testtest
SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 10 08:36:06 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create or replace procedure AA as
  2  begin
  3  null;
  4  /*comments*/
  5  end;
  6  /
Procedure created.  

接下来，我们将把程序保存到操作系统中:

Next we will save the procedure into the OS:

SQL> save aa.sql
Created file aa.sql
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@HOSTNAME:/home/oracle/USER/wrapTest> ll
total 12K
drwxr-x---. 4 oracle oinstall 4.0K Oct 10 08:36 ../
-rw-r-----. 1 oracle oinstall   66 Oct 10 08:37 aa.sql
drwxr-x---. 2 oracle oinstall 4.0K Oct 10 08:37 ./

保存后，我们将使用种子包裹实用程序对软件包进行模糊处理:

After saving it we will use the seeded wrap utility to obfuscate the package:

oracle@HOSTNAME:/home/oracle/USER/wrapTest> wrap iname=aa.sql oname=aa.pls
PL/SQL Wrapper: Release 11.2.0.3.0- 64bit Production on Fri Oct 10 08:37:29 2014
Copyright (c) 1993, 2009, Oracle.  All rights reserved.
Processing aa.sql to aa.pls

现在让我们看一下它的外观:

Now lets see what it looks like:

oracle@HOSTNAME:/home/oracle/USER/wrapTest> cat aa.
aa.pls  aa.sql
oracle@HOSTNAME:/home/oracle/USER/wrapTest> cat aa.pls
create or replace procedure AA wrapped
a000000
1f
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
22 55
7weeW1mRAdYVG9cX0WEujCaQghIwg5nnm7+fMr2ywFy49cO4dIvAwDL+0oabmYEILYsGwIHH
LcmmpnWE55Q=

/

因此我们将代码复制到该链接中，结果如下所示:

So we copy that code into that link and this is what it looks like:

如您所见，我们丢失了注释，但是检索了代码.

As you can see we lost the comments but retrieved the code.

这篇关于取消包装Oracle软件包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！