DBA_SOURCE

Source of all stored objects in the database

Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
NAME VARCHAR2 (30)
Name of the object
TYPE VARCHAR2 (12)
Type of the object: "TYPE", "TYPE BODY", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY" or "JAVA SOURCE"
LINE NUMBER

Line number of this line of source
TEXT VARCHAR2 (4000)
Source text

Usage:


cursor cur_source(c_name  in dba_objects.object_name%type
                , c_type  in dba_objects.object_type%type
                , c_owner in dba_objects.owner%type)
is select line
   ,      text 
   from dba_source
   where name = c_name
   and   type = c_type
   and   owner = c_owner;