<< ibec_RecompileTrigger | IBEBlock | ibec_CompareTables >>

ibec_RecompileProcedure

Recompiles stored procedures.

Syntax

 function ibec_RecompileProcedure(Connection : variant; ProcedureName : string) : string;

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.

Examples 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

See also:
Recompile all Stored Procedures and Triggers

back to top of page
<< ibec_RecompileTrigger | IBEBlock | ibec_CompareTables >>