Today, I know how to wrap Oracle objects called stored procedure, functions, views and so on. It's because I want to make secure for our project source.

How-to-do is very simple.

1) Open common prompt 2) and go to Bin folder under Oracle just like "C:\Oracle\Bin" 3) Then type following script

view plain print about
1C:\Oracle\Bin\wrap iname=/SP/mysp.sql oname=/SP/wrap_mysp.sql

After that, you will get new wrapped sql file under "/SP/" folder. When you open this sql file, you will get your SP scripts are wrapped as follow.

view plain print about
1CREATE OR REPLACE PROCEDURE PPSHEIN_SP wrapped
2a000000
3b2
4abcd
5abcd
6abcd
7abcd
8abcd
9abcd
10abcd
11abcd
12abcd
13abcd
14abcd
15abcd
16abcd
17abcd
18abcd
197
20492 24c
21uVMUVjzbsZm3pHYg5HN17eeE9qQwgzter8BufHTNWGRQ8FWI6Ad2al2PBAJ81mKxp+vAm9Bd
22htWvFcKJdmVey1SnXbDBSa2iwrRD43xT0xbAWFDbUsU+ceb6ve/dj+5qovhIBl4dlM8ejNOg
235vLgybyGz/05C1ane+QofNGB0H7ifBonKCoF38ai89iIeRyyCyl0/ddo7xt2s2V8lOlFVDxW
24fg5BXQpkUO8KDrJaokMQbV1wKt+WtlbZiu4+yo8ODB0+2ulzfAvUCnc4gquAMYJHaSUqDBv0
25nIwppTe6LD5bMJBwCw3vLQrtlHm8NIC6XGS0KLyDdyldBl/9vZ84iE8EBD+djHSJRYv7IzeV
26EbuwLEY/to3vg8DDgywNLPQVI8+lrIXC458HkgdrUxFZQic0WN5/Vc1jACfXq5rTbypIeFPi
2748dgewa12XPBTEOWrOWSoRH9nLe04v6wCDLgSG4FjehswTmHYX2Yk+kpSfktBDAOY7AlZSjb
28JVM2m/49+pk/PzeDsWJ6n1L+IWyoc6s9fgoDeLCmwvef2q+CAOayT08jYDTiO0ZM+IaWw9y2
29LA==
30
31/

This entry was posted on March 25, 2012 at 6:44 PM and has received 1098 views. There are currently 0 comments. Print this entry.