Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_STORED_SETTINGS

ALL_STORED_SETTINGS provides information about the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges.

Related Views

Column Datatype NULL 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 NUMBER NOT NULL Object number of the PL/SQL unit
OBJECT_TYPE VARCHAR2(12)   The type of PL/SQL unit: PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER, TYPE, or TYPE BODY
PARAM_NAME VARCHAR2(30)   The name of the parameter stored persistently with the PL/SQL unit
PARAM_VALUE VARCHAR2(4000)   The TO_CHAR() representation of the value of the persistently stored parameter. The width of this column is operating system dependent; however, it is never less than 255.

Note:

This view is deprecated in favor of the ALL_PLSQL_OBJECT_SETTINGS view. Oracle recommends that you use ALL_PLSQL_OBJECT_SETTINGS instead. ALL_STORED_SETTINGS is retained for backward compatibility only.