SYS_ROUTINE_ROUTINE_USAGE

Information on the routines (procedures and UDFs) that are called in other routines.

Column name	Data type	Contents
SPECIFIC_SCHEMA	CHAR(31)	Name of the schema to which the calling routine belongs
SPECIFIC_NAME	CHAR(31)	Specific name of the calling routine
ROUTINE_SCHEMA	CHAR(31)	Name of the schema to which the called routine belongs
ROUTINE_NAME	CHAR(31)	Specific name of the called routine

Table 127: SYS_ROUTINE_ROUTINE_USAGE view of the SYS_INFO_SCHEMA