SYSPROCPARMS system view

CREATE VIEW SYS.SYSPROCPARMS ( creator, parmname, procname,
parmtype, parmmode, parmdomain, length, remarks )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
			WHERE user_id = SYSPROCEDURE.creator ),
		parm_name, proc_name, parm_type,
		IF parm_mode_in = 'Y' AND
			parm_mode_out = 'N' THEN 'IN'
		ELSE IF parm_mode_in = 'N'
			AND parm_mode_out = 'Y' THEN 'OUT'
		ELSE 'INOUT' ENDIF ENDIF,
		( SELECT domain_name FROM SYS.SYSDOMAIN
			WHERE domain_id = SYSPROCPARM.domain_id ),
		width, SYSPROCPARM.remarks
FROM SYS.SYSPROCPARM == SYS.SYSPROCEDURE

Lists all the procedure parameters from SYSPROCPARM in a readable format.