The VALIDATE procedure provides the capability to change
the state of an invalid routine to valid.
Syntax
>>-DBMS_UTILITY.VALIDATE--(--object_id--)----------------------><
Parameters
- object_id
- An input argument of type INTEGER that specifies the identifier
of the routine to be changed to a valid state. The ROUTINEID column
of the SYSCAT.ROUTINES view contains all the routine identifiers.
Authorization
EXECUTE privilege on the DBMS_UTILITY
module.