The USER_SOURCE view provides the information about all programs owned by the current user.
Parameter | Type | Description |
---|---|---|
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 source code line number relative to a specified program. |
text | TEXT | The line of source code text. |