Where can be found implementations of built-in Oracle PL/SQL packages? For example, there can be found specification stdspec.sql with impl. stdbody.sql. But for package DBMS_ASSERT there is only spec. dbmsasrt.sql. Where can be found implementation? (using version 11.2)
A:
The system packages are compiled in the SYS schema. In my 10GR2 database the package bodies are wrapped and my guess is that they will be wrapped in 11G as well. So you cannot have a look at the implementations.
Rene
2010-09-06 05:40:24
Thanks, you're right. DBMS_ASSERT is located in prvtasrt.plb
2010-09-06 06:56:57
Also, I think some of the bodies are mappings onto C and/or Java libraries rather than written in pl/sql themselves (i.e. XMLDOM).
JulesLt
2010-09-06 15:32:59
A:
Maybe you could give http://technology.amis.nl/blog/4753/unwrapping-10g-wrapped-plsql a try (I never used if). There's sample Java and PL/SQL code to automate whole thing on the bottom of article.
eyescream
2010-09-06 05:47:24
A:
Oracle PL/SQL Built Ins Pocket Reference was good for 8i/9i: Oracle PL/SQL Built-ins Pocket Reference
Sumnibot
2010-10-19 15:19:49