RE: Unwrapping a package

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 17 Nov 2006 15:28:09 -0600

This was just discussed here back at the beginning of the month (the
archives at //freelists.org are a great resource).  Anyway, up to
9i, wrapping was an obfuscation.  If you look at a wrapped package, you
can easily decipher the plain text variables and other goodies, but not
the code.  In 10g, wrapping is supposedly encrypted, which makes it
significantly more difficult to reverse.  Well, provided the method of
encryption can not be as easily brute forced as user$.password is.

From my observation, it appears that packages wrapped in 9i can execute
in 10g, which *I'm guessing* <insert disclaimer here> could mean they're
as suseptible to unwrapping as in a 9i DB, but I haven't had the time
nor need to attempt it (yet!).  I'm also guessing that a 10g wrapped
package would not compile/execute in 9i.  Ooh, to have a few days to
play...

Rich


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Richard J. Goulet
Sent: Friday, November 17, 2006 9:20 AM
To: oracle-l
Subject: RE: Unwrapping a package

 Only way I know of to unwrap a stored procedure is to send it to Oracle
along with a signed but otherwise blank check.


 
Dick Goulet, Senior Oracle DBA
45 Bartlett St  Marlborough, Ma 01752, USA
Tel.: 508.573.1978 |Fax:  508.229.2019 | Cell:508.742.5795 
RGoulet@xxxxxxxxxx
: POWERING TRANSFORMATION 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jesse, Rich
Sent: Thursday, November 16, 2006 1:35 PM
To: oracle-l
Subject: RE: Unwrapping a package

Yes, especially on my birthday and at Christmas.  If you're talking
about Oracle, what version?

In any case, check out http://www.petefinnigan.com

With apologies to Mladen,
Rich 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of MVR
Sent: Wednesday, November 15, 2006 10:05 PM
To: oracle-l
Subject: Unwrapping a package

Fellas,

Does anyone know how to unwrap a package?

TIA,
MVR
--
//www.freelists.org/webpage/oracle-l


Other related posts: