Description
Recompiles one or more specified stored procedures.
Syntax
Recompile_Proc (procnamelist)
Parameters
The Recompile_Proc subroutine has the following parameter.
| Parameter | Description |
|---|---|
| procnamelist | Specifies a name or list of names of stored procedures to recompile. |
Note: Stored procedures can also be recompiled using the Repository('COMPILE') function, or the RTP5 subroutine.
Note: $INSERT records in a stored procedure are not recompiled by Recompile_Proc. However, they are recompiled by the Repository('COMPILE') function.
See Also
Repository('COMPILE'), Repository("TCOMPILE"), RTP5 subroutine
Example
* Recompiles the QUICK_REPORT stored procedure.
Recompile_Proc("QUICK_REPORT")
If Get_Status(ErrCodes) Then
GoSub ErrorHandling
End
