asked on

encrypt my pl/sql

I need to encrypt my pl/sql procedure which stored in oracle ,and no one can retrive the source code from the Dictionary Views.
What can I do?
thanks.

ASKER CERTIFIED SOLUTION

dbalaski

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sidcap

I have to wrap your code. Depending on the client version use are using you will have to execute wrap.exe or wrap80.exe.

That's exactly what you need.

Hope this helps, SIDCAP.

dbalaski

BTW -- the Wrap utility is not only available in oracle 8i -- it is in oracle 7 as well.

dBalaski

sidcap

sorry dbalaski; I have not notified about your answer.

Sorry once again, SIDCAP

dbalaski

its okay -- our entry times are close (12:34 to 12:34)
I guess i submitted a few seconds before you...

dBalaski

wangweiww

ASKER

thanks dbalaski and sidcap,

c:\tmp\t.sql has the following function:
create or replace function f_test return varchar2
is
begin
return '12345';
end;

but
wrap iname=c:\tmp\t.sql
kgepop: no error frame to pop to for error 1801

why ?
thanks

dbalaski

Hi,

From what I have read, kgepop is usually a memory error..

I just tried your code on my Sun E5000 under Oracle 8.1.6 -- worked fine:

$ cat testwrap.sql
create or replace function f_test return varchar2
is
begin
return '12345';
end;
$
$ wrap iname=testwrap.sql

PL/SQL Wrapper: Release 8.1.6.0.0 - Production on Sat Jun 09 23:36:13 2001
Copyright (c) Oracle Corporation 1993, 1994, 1995, 1996, 1997, 1998, 1999. Alld
Processing testwrap.sql to testwrap.plb
$
$ cat testwrap.plb
create or replace function f_test wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
1
8
8106000
1
4
0
5
2 :e:
1FUNCTION:
1F_TEST:
1RETURN:
1VARCHAR2:
112345:
0

0
0
14
2
0 a0 1d 8d a0 b4 a0 2c
6a a0 6e 65 b7 a4 b1 11
68 4f 17 b5
14
2
0 3 7 10 c b 21 25
29 2d 31 36 3a 3c 40 42
4e 52 54 5d
14
2
0 :2 1 a 11 0 18 :3 1 8
:9 1
14
2
0 :4 1 0 :3 1 :3 4 :2 3 :6 1
5f
4
:2 0 8 1 :4 0
3 :3 0 3 :3 0
2 :a 0 10 1
:4 0 4 :3 0 5
6 0 10 3
7 :2 0 3 :3 0
5 :4 0 a :2 0
c 3 f :3 0
f 0 f e
c d :6 0 10
:2 0 3 7 f
12 :2 0 2 10
13 :8 0
5
4
:3 0 1 b
1
4
0
12
0
1
14
1
1
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0
3 0 1
0

/
-------------------------------------

I see you are using NT, check to see if there is WRAP23.exe and WRAP80.EXE
Try one of those ...

dBalaski

wangweiww

ASKER

thanks dbalaski
I think it the right way to encrypt my pl/sql.

But I still can not run wrap correctly.(error msg: kgepop: no error frame to pop to for error 1801)
I am using Oracle 8.1.5 for NT and can not find the WRAP23.exe and WRAP80.EXE .