Home » SQL & PL/SQL » SQL & PL/SQL » Unable to view package body in SQLplus using DBA_SOURCE table (Oracle 10g)
Unable to view package body in SQLplus using DBA_SOURCE table [message #564251] Wed, 22 August 2012 06:40 Go to next message
zaff
Messages: 31
Registered: July 2008
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
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 Go to previous messageGo to next message
cookiemonster
Messages: 10960
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's wrapped. Wrapping is done to prevent people reading the source code
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59088
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
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 Go to previous messageGo to next message
zaff
Messages: 31
Registered: July 2008
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
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 Go to previous message
Michel Cadot
Messages: 59088
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
Previous Topic: select_question
Next Topic: PL/SQL Help
Goto Forum:
  


Current Time: Wed Sep 17 00:57:28 CDT 2014

Total time taken to generate the page: 0.10655 seconds