USER_SOURCE v17

The USER_SOURCE view provides information about all programs owned by the current user.

NameTypeDescription
schema_nameTEXTName of the schema in which the program belongs.
nameTEXTName of the program.
typeTEXTType of program. Possible values are: FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, and TRIGGER.
lineINTEGERSource code line number relative to a given program.
textTEXTLine of source code text.