Status Property

See Also

Example

Applies To

OraParameter

OraParamArray

Description

Returns an integer indicating the status of the specified parameter. Not available at design time and read-only at run time.

Usage

parameter_status = oraparameter.Status

parameter_status = oraparamarray.Status

Remarks

The Status property is interpreted as a series of bits, each providing information about the parameter. Parameters can be bound only if they are enabled, and can be enabled only if they are auto-enabled.

The parameter Status property bit values are:

Parameter Status Property Bit Values

Constant	Value	Description
ORAPSTAT_INPUT	&H1&	Parameter can be used for input.
ORAPSTAT_OUTPUT	&H2&	Parameter can be used for output.
ORAPSTAT_AUTOENABLE	&H4&	Parameter is AutoBindEnabled.
ORAPSTAT_ENABLE	&H8&	Parameter is Enabled. This bit is always set.

These values are located in the file ORACLE_BASE\ORACLE_HOME\oo4o\oraconst.txt.

Data Type

Integer