Reference Guide > TDV and Business Directory System Tables > ALL_PROCEDURES
 
ALL_PROCEDURES
The ALL_PROCEDURES system table exposes all published procedures to which the current user has access. Users can see procedures for which they have at least one privilege.
Column
TDV
JDBC Data Type
Nullable
Description
PROCEDURE_ID
INTEGER
 
Identifier of the procedure. Primary key.
PROCEDURE_NAME
VARCHAR(255)
 
Name of the procedure.
PROCEDURE_TYPE
SMALLINT
 
Procedure type. Possible values:
1—A relational data source.
2—A WSDL type of data source.
3—A flat file.
4—The workspace.
5—An LDAP data source.
BD_PROCEDURE_TYPE
CHAR
 
BD type of the procedure.
SCHEMA_ID
INTEGER
Yes
Identifier of the schema.
SCHEMA_NAME
VARCHAR(255)
Yes
Name of the schema.
CATALOG_ID
INTEGER
Yes
Identifier of the catalog.
CATALOG_NAME
VARCHAR(255)
Yes
Name of the catalog.
DATASOURCE_ID
INTEGER
 
Identifier of the data source.
DATASOURCE_NAME
VARCHAR(255)
 
Name of the data source.
BD_DATASOURCE_NAME
VARCHAR(255)
 
BD name of the data source.
SITE_NAME
VARCHAR
 
Name of the site.
GUID
VARCHAR(36)
 
Nearly unique 128-bit identifier.
ANNOTATION
VARCHAR(2147483647)
 
Annotation for the procedure.
OWNER_ID
INTEGER
 
Identifier of the person who created or owns the procedure.
OWNER
VARCHAR(255)
 
User name of the person who created or owns the procedure.
PARENT_PATH
VARCHAR(787)
 
Path to the parent container.
BD_PARENT_PATH
VARCHAR
 
BD path to the parent container.
PROCEDURE_CREATOR_ID
INTEGER
 
Identifier of the user who created this procedure. Same as USER_ID in ALL_USERS.
PROCEDURE_
CREATION_TIMESTAMP
BIGINT
 
Timestamp when the procedure was created.
PROCEDURE_MODIFIER_ID
INTEGER
 
Identifier of the user who last modified this procedure. Same as USER_ID in ALL_USERS.
PROCEDURE_
MODIFICATION_TIMESTAMP
BIGINT
 
Timestamp when the procedure was modified.
LAST_MODIFICATION_
TIMESTAMP
BIGINT
 
Timestamp when the procedure was last modified.