SQL Guide : Database system tables and system views : System tables : SYS_PROCEDURES
  
SYS_PROCEDURES
This system table lists procedures.
Specific users are restricted from viewing procedures. Owners are restricted to viewing procedures they have created. Users can only view procedures to which they have execute access to see the procedure definition. If users have no access rights, they are restricted from viewing all procedures. Note that execute access does not allow users to see procedure definitions. No restrictions apply to DBAs.
Column name
Data type
Description
ID
INTEGER
Unique procedure identifier.
PROCEDURE_NAME
WVARCHAR
Procedure name.
PROCEDURE_TEXT
LONG WVARCHAR
Procedure body.
PROCEDURE_BIN
LONG VARBINARY
Compiled form of the procedure.
PROCEDURE_SCHEMA
WVARCHAR
The name of the schema containing PROCEDURE_NAME.
PROCEDURE_CATALOG
WVARCHAR
The name of the catalog containing PROCEDURE_NAME.
CREATIME
TIMESTAMP
Creation time.
TYPE
INTEGER
Reserved for future use.
See also
System tables