A script-enabled browser is required for this page to function properly.

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.

SET_PARAMETER_ATTR Built-in