Home » RDBMS Server » Server Administration » Wrapped Packages (10.2.0.2.0)
Wrapped Packages [message #393346] Sat, 21 March 2009 20:50 Go to next message
jcyp_71
Messages: 15
Registered: March 2009
Junior Member
Hello,

In what dba table (if any) can i find out if a package, procedure or function is wrapped?

Thanks in advance.

Report message to a moderator

Re: Wrapped Packages [message #393349 is a reply to message #393346] Sat, 21 March 2009 21:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
user_source/dba_source.
If the code is wrapped, you will not see the code.

Report message to a moderator

Re: Wrapped Packages [message #393350 is a reply to message #393349] Sat, 21 March 2009 21:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Something like this.
The source code should be compiled in database using the wrapped file (.plb by default).
NAME                           TEXT
------------------------------ ------------------------------------------------------------
VWISEXISTS                     FUNCTION VWIsExists wrapped
                               a000000
                               1
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               abcd
                               8
                               ff eb
                               z/cx74MEDJ9hStrYwmjtd3TQsLQwgwJKLdPWfOdAmNSwcHc7sSq2LkvAsNsM
                               40U6+SCzFCNM
                               mKYkzyR8yVKXNXAFrbOvoV6d4Ntsr0CzLgQPHaIldkRUjnwyYP0XGKBVEyJW
                               kL63a9ZxK+GH
                               b5tf8v7Ca+wdcdwFZ4D2AHEnA64Uyu7STTBKqG1bYjt7ZbHN+a20G2xyA3NC
                               5q/gklu3ztO7
                               MYHm+yf+CERYJ3qe

Report message to a moderator

Re: Wrapped Packages [message #393368 is a reply to message #393350] Sun, 22 March 2009 04:00 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member
Dear Sir

Is it possible to unwrap this(or any wrap object) pakage any way ?


Best Regards
Halim

Report message to a moderator

Re: Wrapped Packages [message #393369 is a reply to message #393368] Sun, 22 March 2009 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel

Report message to a moderator

Re: Wrapped Packages [message #393379 is a reply to message #393368] Sun, 22 March 2009 07:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
By regular means NO. There is no built-in mechanism to do it.
But there are some covert methods that rely on specific loop holes to unwrap the code. Methods depend on versions and not recommended for all.

[Updated on: Sun, 22 March 2009 07:16]

Report message to a moderator

Re: Wrapped Packages [message #393397 is a reply to message #393379] Sun, 22 March 2009 09:40 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member
Dear sir Mahesh Rajendran

if you give some clue/something details its help me great.
(if you No problem)

Database version: 10.2.0.1

best regards
Halim

[Updated on: Sun, 22 March 2009 09:44]

Report message to a moderator

Re: Wrapped Packages [message #393402 is a reply to message #393397] Sun, 22 March 2009 10:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://technology.amis.nl/blog/4753/unwrapping-10g-wrapped-plsql
And
>>Dear Sir Mahesh Rajendran

As far as I can remember, I have never been knighted.
So please drop Sir. Wink

Report message to a moderator

Re: Wrapped Packages [message #393421 is a reply to message #393402] Sun, 22 March 2009 14:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Dear sir Mahesh Rajendran

You could also post all the hack against the database or the links that explain how to do it you know.

Why not create a "Hack Oracle database" forum, I'm pretty sure it will have a big success.

Regards
Michel

Report message to a moderator

Re: Wrapped Packages [message #393423 is a reply to message #393421] Sun, 22 March 2009 14:53 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Michel,
you are just shooting the messenger Wink.
It is not new. It is not secret. But seems visible only to the
informed folks.

I totally understand and agree with your concern though.

Regards
Mahesh Rajendran

Report message to a moderator

Previous Topic: Analyze schema
Next Topic: Automating tablespace administration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 03:53:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.