WRAP.EXE: are there alternatives?

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

On Jan 25, 9:57 am, "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, Wageningenhttp://www.stoas.nl

An alternative tool *supported by Oracle*?
Why?
If there are bugs in Microsoft tools do you ask for a similar
replacement tool?
Or do you ask Microsoft to address the bug?
I think you should submit a SR.
Oracle will probably not do anything if the problem doesn't exist in
10g, as 9i is going to be desupported soon.

--
Sybrand Bakker
Senior Oracle DBA

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

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/Yx4djWgOf8VqON7zzAwgy5Kf8sVfC82JnMYYjesKFSO9BAOhPq QAU/3mI7jqzY6
nUsOawWILi0+9g5UgjjtnbHBHlIdHwdAGgLwZF1VWhdvW47sFg SsKy3NP7GybT6jLLDYgidr
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

> 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

Just add the line:

DA Morgan wrote in
news:1169746521.161795-at-bubbleator.drizzle.com:

> 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
>
> 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/Yx4djWgOf8VqON7zzAwgy5Kf8sVfC82JnMYYjesKFSO9BAOhPq QAU/3mI7jqzY
> 6
> nUsOawWILi0+9g5UgjjtnbHBHlIdHwdAGgLwZF1VWhdvW47sFg SsKy3NP7GybT6jLLDYgid
> r NLR83MNwUxbZri2iJ1VSKFxwByADhXy2So8k0koUFU1U/MTkix2B3T6y
>
> /
>

When I use your testproc and try to wrap I get the following message:

PSU(103,1,6,23):Encountered the symbol "JOIN" when expecting one of the
following:

, ; for group having intersect minus order start union where
connect

I discovered that 6, 23 refers to line and position, and found out that
in all my testcases there was either JOIN, MERGE, CASE and some other
keywords.
When I use Ian M's solution it wraps OK. Output looks quite different
from yours. Maybe depending on which platform Oracle runs on? In my case:
MS Windows Server 2003 EE sp1.

Regards,
Henk Hultink

H. Hultink schreef:

> When I use Ian M's solution it wraps OK. Output looks quite different
> from yours. Maybe depending on which platform Oracle runs on? In my case:
> MS Windows Server 2003 EE sp1.

What is the version of wrap.exe? In which tree
(ORACLE_HOME) do you execute it?
Beginning to suspect you have a V8 or 9 wrapper,
where you ought to have a V10
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Frank van Bortel wrote in
news:epfk3e$jhu$1-at-news4.zwoll1.ov.home.nl:

> H. Hultink schreef:
>
>> When I use Ian M's solution it wraps OK. Output looks quite different
>> from yours. Maybe depending on which platform Oracle runs on? In my
>> case: MS Windows Server 2003 EE sp1.
>
> What is the version of wrap.exe? In which tree
> (ORACLE_HOME) do you execute it?
> Beginning to suspect you have a V8 or 9 wrapper,
> where you ought to have a V10

I have used WRAP80.EXE as well as WRAP.EXE (here the version number has
disappeared...) on an Oracle9i database server on [ORACLE_HOME]\bin. The
results in both cases were the same. Nb The database version is 9.2.0.8.0

Regards,
Henk

wrap has a hidden parameter that will allow you past this issue.

$ wrap sequlfile.sql edebug=wrap_new_sql


should do the trick