Re: WRAP.EXE: are there alternatives?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 25 Jan 2007 09:35:20 -0800
Message-ID: <1169746521.161795_at_bubbleator.drizzle.com>

[Quoted] H. Hultink wrote:
> Hi,
>
> I am looking for a way to encrypt PL/SQL code.
> I used Oracle WRAP.EXE (Oracle version 9.2.0.8.0), but I discovered that it
> cannot encrypt the code when this contains for example:
>
> JOIN
> CASE
> MERGE
>
> Is there an alternative tool available anywhere?
> Please respond to the group.
>
> TIA,
> Regards,
> Henk Hultink
> Stoas, Wageningen
> http://www.stoas.nl

[Quoted] Where did you get your information?

Before:

---

CREATE OR REPLACE PROCEDURE testproc IS
  x POSITIVE;
BEGIN
   SELECT COUNT(*)
   INTO x
   FROM user_tables t JOIN user_indexes i    ON t.table_name = i.table_name;
END testproc;
/

After:

---

CREATE OR REPLACE PROCEDURE testproc wrapped a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
9d ca
FBXvKE+s/Yx4djWgOf8VqON7zzAwgy5Kf8sVfC82JnMYYjesKFSO9BAOhPqQAU/3mI7jqzY6 nUsOawWILi0+9g5UgjjtnbHBHlIdHwdAGgLwZF1VWhdvW47sFgSsKy3NP7GybT6jLLDYgidr NLR83MNwUxbZri2iJ1VSKFxwByADhXy2So8k0koUFU1U/MTkix2B3T6y

/

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Jan 25 2007 - 18:35:20 CET