[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 636
  • 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 GruwezOracle dbaCommented:
legally, the easiest way,
go work at oracle :)
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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