meta data for this page
ibec_RecompileProcedure
Recompiles stored procedures.
Description
This function recompiles (alters using current procedure source) a specified stored procedure and returns an empty string if no error occurs or an error message otherwise. Instead of a procedure name you can specify an empty string to recompile ALL database stored procedures.
Syntax
function ibec_RecompileProcedure(Connection : variant; ProcedureName : string) : string;
Example of usage
1. Recompile a single stored procedure using the current connection:
execute ibeblock returns (ErrMessage varchar(1000)) as begin db = ibec_GetDefaultConnection(); ErrMessage = ibec_RecompileProcedure(db, 'MY_PROC'); if (ErrMessage <> '') then suspend; end
2. Recompile ALL database procedures using the current connection:
execute ibeblock returns (ErrMessage varchar(10000)) as begin ErrMessage = ibec_RecompileProcedure(0, ''); if (ErrMessage <> '') then suspend; end