Set the Resource Timeout Limit

Use this API to set the current session timeout limit for all user database accounts (for example, change the default limit of 24 hours to 8 hours). This parameter has a default of 180 minutes with a minimum of 30 minutes and a maximum of 1440 minutes (24 hours)

Name

CDR_PUB_ResourceLimits.setResourceLimit

Signature

PROCEDURE setResourceLimit
  ( 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 VARCHAR2
  , p_value            IN VARCHAR2
  );

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.
  • CONNECT_TIME
• P_VALUE (Mandatory) Enter a minimum of 30 minutes and a maximum of 1440 minutes (24 hours). (The default is 180 minutes [24 hours]).