The DBA_SOURCE view provides a list of source code for all objects in the database.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which the program belongs. |
schema_name | TEXT | The name of the schema to which the program belongs. |
name | TEXT | The name of the program. |
type | TEXT | The type of the program. Valid values: FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, and TRIGGER. |
line | INTEGER | The line number of the source code in a specified program. |
text | TEXT | The line of the source code text. |