GET_PARAMETER_ATTR Built-in
Description
Returns the current value and type of an indicated parameter in an indicated parameter list.
Syntax
FUNCTION GET_PARAMETER_ATTR
(list PARAMLIST,
key VARCHAR2,
paramtype NUMBER,
value VARCHAR2);
FUNCTION GET_PARAMETER_ATTR
(name VARCHAR2,
key VARCHAR2,
paramtype NUMBER,
value VARCHAR2);
Built-in Type unrestricted procedure that returns
two OUT parameters
Enter Query Mode yes
Parameters
- list or name
-
- Specifies the parameter list to which the parameter is assigned. The actual
parameter can be either a parameter list ID of type PARAMLIST,
or the VARCHAR2 name of the parameter list.
-
- key
-
- The VARCHAR2 name of the parameter.
-
- paramtype
-
- An OUT parameter of type NUMBER.
The actual parameter you supply must be a variable of type NUMBER,
and cannot be an expression. Executing the parameter sets the value of the
variable to one of the following numeric constants:
DATA_PARAMETER Indicates that the parameter's
value is the name of a record group.
TEXT_PARAMETER Indicates that the parameter's
value is an actual data value.
-
- value
-
- An OUT parameter of type VARCHAR2.
If the parameter is a data type parameter, the value is the name of a record
group. If the parameter is a text parameter, the value is an actual text parameter.
Related topic
SET_PARAMETER_ATTR Built-in