查询数据库某个用户都有哪些存储过程

SELECT
LINE,
TEXT
FROM
ALL_SOURCE
WHERE
OWNER = 'P1RPTODS'
AND NAME = 'SP_EXEC_MES_TABLE'
AND TYPE = 'PROCEDURE'
ORDER BY
LINE;

SP_EXEC_MES_TABLE
SP_EXEC_PROC
SP_EXEC_SQL
SP_MAX_RPT_RUN_DATE
SP_ODS
SP_ODS_PROCESS
SP_ODS_PROCESS_FIX
SP_OHEDC
SP_OHLOTBASE_KEYLINK
SP_OHQT
SP_OMLOT
SP_REFKEY
SP_RUN_ALL
SP_RUN_FIX
SP_TRUNCATE_ALL_TABLE

SELECT
OWNER,
OBJECT_NAME
FROM
ALL_PROCEDURES
WHERE
OWNER = 'P1RPTODS' AND OBJECT_TYPE = 'PROCEDURE' ORDER BY
OBJECT_NAME;