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. |