VALIDATE procedure - Change an invalid routine into a valid routine

The VALIDATE procedure provides the capability to change the state of an invalid routine to valid.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_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.