SYS.ALL_STORED_SETTINGS

The ALL_STORED_SETTINGS view describes the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges.

ALL_STORED_SETTINGS is retained for backward compatibility. Use the ALL_PLSQL_OBJECT_SETTINGS view instead.

Related views

SYS.DBA_STORED_SETTINGS describes the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges. It also returns parameter information for all objects in the database.
SYS.USER_STORED_SETTINGS describes the persistent parameter settings for stored PL/SQL units, but only shows information about PL/SQL units owned by the current user.

Columns

Column name	Type	Description
OWNER	VARCHAR2 (30) NOT NULL	Name of the database user owning the stored PL/SQL unit.
OBJECT_NAME	VARCHAR2 (30) NOT NULL	Name of the PL/SQL unit.
OBJECT_ID	TT_BIGINT NOT NULL	Object number of the PL/SQL unit.
OBJECT_TYPE	VARCHAR2 (12) NOT NULL	The type of the PL/SQL unit: PROCEDURE,FUNCTION, PACKAGE or PACKAGE BODY.
PARAM_NAME	VARCHAR2 (30) NOT NULL	The name of the parameter stored persistently with the PL/SQL unit.
PARAM_VALUE	VARCHAR2 (4000) NOT INLINE	The TO_CHAR () representation of the value of the persistently stored parameter. The width of this column is operating system dependent; however, it is not less than 255.