OraFAQ Forum: SQL & PL/SQL » Unable to view package body in SQLplus using DBA

Home » SQL & PL/SQL » SQL & PL/SQL » Unable to view package body in SQLplus using DBA_SOURCE table (Oracle 10g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Unable to view package body in SQLplus using DBA_SOURCE table [message #564251]

Wed, 22 August 2012 06:40

zaff
Messages: 28
Registered: July 2008

Junior Member

Hi,
I'm trying to view the package body of a package. However, when i execute the following query, i get a random selection of letters/numbers:

select text 
from dba_source 
where type='PACKAGE BODY' AND name ='MY_PACKAGE';

PACKAGE BODY my_package wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
605ae e83e
7bgZ8AnLrpqnR6P6HtWbwYauOxswg83tur/9gPF8U2S6nWbBayhpn70bbDolUQ5ON2fMov14
H6byz4h2rrqCzQMcmNBiqtrtHnO7E/72oskra2fMZVfrZZONWI2IiIjziLHXkZLNXTIu4rED
EpuGJKqSzaX4IJq1sdplMW9GyBNzJ0UTZOqRvFUg3gPJnYM8IMEFVc+B7HSTmZIDraW/WzOb
S3WWwZhqMz8SdXLjOn9iYFqGnYq5eDI+B378VbyTs6E7H4GRbEmEquj4yZhItKrOpvWjAvnb
YYd366S+VthyGSEeY4F5Hj0TBUUmvd8If7xNChVHCEjCj52XQocpeF5/AOYr+EMyVaUfsYEe
........
........
........

Please help.

Thanks in advance,
Zaff

Report message to a moderator

Re: Unable to view package body in SQLplus using DBA_SOURCE table [message #564253 is a reply to message #564251]

Wed, 22 August 2012 06:43

cookiemonster
Messages: 9290
Registered: September 2008
Location: Rainy Manchester

Senior Member

It's wrapped. Wrapping is done to prevent people reading the source code

Report message to a moderator

Re: Unable to view package body in SQLplus using DBA_SOURCE table [message #564256 is a reply to message #564251]

Wed, 22 August 2012 06:46

Michel Cadot
Messages: 54712
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The package is wrapped, you can't see the actual source.
(If it was YOUR package then you should know you have wrapped it, conclusion you're trying to hack a package you do not own.)

Regards
Michel

Report message to a moderator

Re: Unable to view package body in SQLplus using DBA_SOURCE table [message #564260 is a reply to message #564256]

Wed, 22 August 2012 06:53

zaff
Messages: 28
Registered: July 2008

Junior Member

Thanks for the prompt response.
Yes, it's not "MY_PACKAGE".
We received code from a vendor that is causing performance issues. I just wanted to take a closer look.

Thanks,
Zabair

Report message to a moderator

Re: Unable to view package body in SQLplus using DBA_SOURCE table [message #564281 is a reply to message #564260]

Wed, 22 August 2012 08:35

Michel Cadot
Messages: 54712
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ask the vendor.
Anyway you are not allowed to modify the code of a vendor.

Regards
Michel

Report message to a moderator

Previous Topic:	select_question
Next Topic:	PL/SQL Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 21:09:49 CDT 2013

Total time taken to generate the page: 0.11078 seconds