Women in Technology

Hear us Roar



Article:
  The Master Key to Oracle's Data Dictionary
Subject:   Most powerful views...
Date:   2002-10-29 01:28:05
From:   chrisrimmer
I like the *_SOURCE views. Having all of the source code of packages available is very powerful. It lets you do things like dynamically recompile packages on the fly to emulate Java Mock Objects for testing, or easily check for references to a given package or procedure call.


But then I'm a developer not a DBA, so I guess I'm bound to find the code objects more interesting!

Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • Most powerful views...
    2002-11-06 11:53:38  neh123us@yahoo.com [View]

    Additional very powerful views are *_errors which will outline details about the compile time errors for a package or stored proedure. If you have a tool that doesn't supply nice error messages, you can always query this.

    All_arguments outlines the paramaters in each of the procedures/functions in a package.

    You can easily query this to produce wrapper classes to wrap around making calls to the stored procs.