Oracle WRAP utility variant - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Oracle WRAP utility variant

Author

Topic

malik_1700
Starting Member

14 Posts

Posted - 2008-09-23 : 23:01:59

Oracle WRAP Utitily Obfuscate the contents of a PL/SQL source file.
Here is the example :

we must create a dummy source file called get_date_string.sql with the following contents.

CREATE OR REPLACE FUNCTION get_date_string RETURN VARCHAR2 AS
BEGIN
RETURN TO_CHAR(SYSDATE, 'DD-MON-YYYY');
END get_date_string;
/

We can then run the wrap utility, specifying our source file.

wrap iname=get_date_string.sql oname=get_date_string_wrap.sql

PL/SQL Wrapper: Release 10.2.0.1.0- Production on Wed Oct 05 10:55:01 2005

Copyright (c) 1993, 2004, Oracle. All rights reserved.

Processing get_date_string.sql to /tmp/get_date_string_wrap.sql

The resulting output files contain the wrapped code which is listed below.

CREATE OR REPLACE FUNCTION get_date_string wrapped
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
71 ae
P29RDhRZX0orO0ED/mMF8i12Glkwg8eZgcfLCNL+XlquYvSuoVah8JbRPpdHDOrnwLK9spte
58d0wDO4dGUJuHSLwMAy/tKGCamhAs7G1hohrO/WTHaEcTKOd0xx9RBzc/XvN2dM6+zZPXLp
r1UqFBwU/Sx2010pwUjXpqZCvywG
/

Is there is any variant of WRAP utility in SQL SERVER 2000,2005,2008

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-09-24 : 04:25:03

Sql Server related questions only plz

malik_1700
Starting Member

14 Posts

Posted - 2008-09-24 : 04:44:25

quote:
Originally posted by lionofdezert

Sql Server related questions only plz

It is related to SQL SERVER .
Is there any utility in SQL SERVER that wraps the SQL FILE
to unreadable format

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources