SYS.ALL_PROCEDURES

The ALL_PROCEDURES view describes all PL/SQL functions and procedures, along with associated properties, that are accessible to the current user.

Related views

• SYS.DBA_PROCEDURES describes all PL/SQL functions and procedures, along with associated properties. It has the same columns as ALL_PROCEDURES.

• SYS.USER_PROCEDURES describes all functions and procedures, along with associated properties that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Owner of the procedure or function
OBJECT_NAME	VARCHAR2(30) INLINE	Name of the object: top-level function, procedure or package name
PROCEDURE_NAME	VARCHAR2(30) INLINE	Name of the procedure or function
OBJECT_ID	TT_BIGINT NOT NULL	Object number
SUBPROGRAM_ID	NUMBER NOT NULL	Unique subprogram identifier
OVERLOAD	VARCHAR2(12) INLINE	Overload unique identifier
OBJECT_TYPE	VARCHAR2(17) INLINE	Object type
AGGREGATE	VARCHAR2(3) INLINE NOT NULL	YES if the object is an aggregate function; NO otherwise TimesTen does not support aggregate functions, so value is NO.
PIPELINED	VARCHAR2(3)INLINE NOT NULL	YES if the object is a pipelined table; NO otherwise TimesTen does not support PIPELINED, so value is NO.
IMPLTYPEOWNER	VARCHAR2(30) INLINE	Name of owner of the implementation type, if any
IMPLTYPENAME	VARCHAR2(30) INLINE	Name of the implementation type, if any
PARALLEL	VARCHAR2(3) INLINE NOT NULL	YES if the procedure or function is parallel-enabled; NO otherwise TimesTen does not support PARALLEL, so value is NO. You can specify the parallel_enable_clause, but it has no effect.
INTERFACE	VARCHAR2(3) INLINE NOT NULL	YES, if the procedure or function is a table function implemented using the Oracle Data Cartridge Interface (ODCI) NO, otherwise TimesTen does not support ODCI so value is NO.
DETERMINISTIC	VARCHAR2(3) INLINE NOT NULL	YES, if the procedure or function is declared to be deterministic NO, otherwise
AUTHID	VARCHAR2(12) INLINE NOT NULL	DEFINER if the procedure or function is declared to execute as definer CURRENT_USER if the procedure or function is declared to execute as invoker