Reset the Resource Timeout Limit

Use this API to reset the current session timeout limit for all user database accounts to the default limit of 24 hours.

Name

CDR_PUB_ResourceLimits.resetResourceLimitToDefault

Signature

PROCEDURE resetResourceLimitToDefault
  ( 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_all              IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE
  );

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_ALL (Mandatory) Enter T (to reset all profile limits to the default and ignore the P_NAME setting) or F (to reset the limit to default for the specified name).