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