> here is my procedure
>
> CREATE PROCEDURE SP_REPLANEAR_OF
> AS
> DECLARE VARIABLE idplano INTEGER;
> DECLARE VARIABLE idplanoaux INTEGER;
> DECLARE VARIABLE idplanoaux1 INTEGER;
> DECLARE VARIABLE idenc INTEGER;
> DECLARE VARIABLE nreg INTEGER;
> DECLARE VARIABLE idgrupo INTEGER;
> DECLARE VARIABLE codmaq VARCHAR(6);
> DECLARE VARIABLE ordem INTEGER;
> DECLARE VARIABLE inicioprev TIMESTAMP;
> DECLARE VARIABLE qtd NUMERIC (18,2);
> DECLARE VARIABLE comprimento NUMERIC (18,2);
> DECLARE VARIABLE tempoprev INTEGER;
> DECLARE VARIABLE fimprev TIMESTAMP;
> DECLARE VARIABLE taxasalarialprev NUMERIC (18,4);

Have you done any re-factoring on this SP at all?

Alan