Hello everybody

I have the following Stored Procedure:

SET TERM ^ ;

CREATE PROCEDURE ACTUALIZAR_FECHA_INVENTARIO
AS
BEGIN

UPDATE PRODUCTOS P
SET P.PRD_FECINV = (SELECT COALESCE(MAX(MC.MVC_FECHAX),
P.PRD_FECINI)
FROM MOVIMCAB MC
INNER JOIN MOVIMDET MD ON (MC.MVC_IDENTI = MD.MOV_IDENTI) AND
(MD.MOV_CODPRD = P.PRD_CODIGO)
WHERE MC.MVC_TIPMOV = 'INV');

COMMIT;

END^

SET TERM ; ^

And the SQL Manager said me that the word COMMIT is a syntax error.
But....if I don't use COMMIT then the column PRD_FECINV is not updated.

Which is the solution?

Thanks in advance.

Walter.


[Non-text portions of this message have been removed]