• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

Want to examine the code for oracle supplied packages

Is there a way to explore oracle supplied packages through a dictionary view or through some other means?

For example, if I want to go explore and examine the code behind DBMS_OUTPUT , how can I find it?

Thanks
0
Mark_Co
Asked:
Mark_Co
1 Solution
 
slightwv (䄆 Netminder) Commented:
All code can be seen in DBA_SOURCE.

Most Oracle code is WRAPPED:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/wrap.htm#LNPLS016

There are some claims around that you can unwrap the code but there are likely license/legal issues in even trying.

Short of that, it is likely in nativly compiled C/Java code.  Not sure how to see that.

I personally feel that you won't be able to 'legally' get what you are after.
0
 
Mark_CoAuthor Commented:
OK, thank you
0
 
DavidSenior Oracle Database AdministratorCommented:
I may easily be mistaken, but I think you will need to first receive the SELECT ANY DICTIONARY system privilege.
0
 
Mark_CoAuthor Commented:
much obliged for the tip
0
 
Geert GOracle dbaCommented:
legally, the easiest way,
go work at oracle :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now