Get the Resource Timeout Limit

Use this API to get the current session timeout limit for all user database accounts.

Name

CDR_PUB_ResourceLimits.getResourceLimit

Signature

PROCEDURE getResourceLimit
  ( p_api_version      IN VARCHAR2
  , p_init_msg_list    IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE
  , p_commit           IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
  , p_validation_level IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL
  , x_return_status    OUT NOCOPY VARCHAR2
  , x_msg_count        OUT NOCOPY NUMBER
  , x_msg_data         OUT NOCOPY VARCHAR2
  , p_name             IN cdr_db_resource_limits.name%TYPE
  , p_value            OUT NOCOPY cdr_db_resource_limits.current_value%TYPE
  );

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• P_NAME (Mandatory) Enter the current value set for the database profile name.

• P_VALUE (Mandatory) Shows the current limit.