RE: I can't unwrap an old 9i wrapped function

There are several known ways to unwrap a stored procedure.

They stated they found a way, but wouldn’t work on 9.

My point, no one should still be on 9 at this point. It’ll be easier no matter once you get up on something newer.

From: Martin Berger <martin.a.berger_at_gmail.com> Sent: Friday, June 29, 2018 1:17 PM
To: Jeff Smith <jeff.d.smith_at_oracle.com> Cc: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>; Oracle-L Freelists <oracle-l_at_freelists.org> Subject: Re: I can't unwrap an old 9i wrapped function

Jeff, 

This doesn't help.

12c can still execute 9i-wrapped code. 

And there is no unwrap/rewrap during the upgrade.

 So even the DB is upgraded, the problem exists :( 

sorry, 

 berx

Jeff Smith <HYPERLINK "mailto:jeff.d.smith_at_oracle.com"jeff.d.smith_at_oracle.com> schrieb am Fr., 29. Juni 2018, 19:06:

I don’t suppose getting rid of your 9g instance and getting into 12c is a possibility?

Or even an 11gR2 XE database?

From: Martin Berger <HYPERLINK "mailto:martin.a.berger_at_gmail.com"martin.a.berger_at_gmail.com> Sent: Friday, June 29, 2018 1:04 PM
To: Juan Carlos Reyes Pacheco <HYPERLINK "mailto:jcdrpllist_at_gmail.com"jcdrpllist_at_gmail.com> Cc: Oracle-L Freelists <HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org> Subject: Re: I can't unwrap an old 9i wrapped function

Unfortunately I don't have a tool, but this presentation by Pete Finnigan will be a good starting point: 

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__www.blackhat.com_presentations_bh-2Dusa-2D06_BH-2DUS-2D06-2DFinnigan.pdf&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=n8OjSEM09yxYSXILFhtu9MQb5psSEFrQhUeBMk2p0jk&s=T1jFzuKLwyd6jtfyFVdtegd7Jo069I1Y6Cb2EIZv2Vo&e="https://www.blackhat.com/presentations/bh-usa-06/BH-US-06-Finnigan.pdf

Hth, 

 berx 

Juan Carlos Reyes Pacheco <HYPERLINK "mailto:jcdrpllist_at_gmail.com"jcdrpllist_at_gmail.com> schrieb am Fr., 29. Juni 2018, 18:04:

Please,I can't unwrap an old 9i wrapped function

currently there are tools for 10g onward wrapped procedures.

like HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__www.codecrete.net_UnwrapIt_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=n8OjSEM09yxYSXILFhtu9MQb5psSEFrQhUeBMk2p0jk&s=ZXNP_WLHB6vh89vYwTn1M_Wz97_qi8qrYcgJsLQjKyI&e="https://www.codecrete.net/UnwrapIt/

for old wrapped there are OracleUnWrapper.exe from softdream but is too expensive.

If someone know about a way to unwrap could you please send me :)

Thank you :)

--
http://www.freelists.org/webpage/oracle-l