SYS.ALL_STORED

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) INLINE`	Name of the database user owning the stored PL/SQL unit
`OBJECT_NAME`	`VARCHAR2(30) INLINE`	Name of the PL/SQL unit
`OBJECT_ID`	`TT_BIGINT NOT NULL`	Object number of the PL/SQL unit
`OBJECT_TYPE`	`VARCHAR2(12) INLINE NOT NULL`	The type of the PL/SQL unit: `PROCEDURE`,`FUNCTION`, `PACKAGE` or `PACKAGE BODY`
`PARAM_NAME`	`VARCHAR2(30) INLINE 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, but it is at least 255.