Reference Manual
   CHAPTER 16. System Views     

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

Presents the procedure parameters from SYSPROCPARM in a more readable format.