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.