Re: declarar una variable dentro de un Procedure??
BEGIN
DECLARE vIdCliente INT DEFAULT 0;
IF pTipoConsulta = 1 THEN
SELECT MAX(idCliente) into vIdCliente
FROM Cliente;
INSERT INTO correos(email, identidad, descripcion, entidad)
VALUES(pEmail, vIdCliente, pDescripcion, pentidad);
END IF;
END
Subject
Views
Written By
Posted
27531
November 24, 2008 10:35AM
5475
November 24, 2008 12:47PM
4000
November 24, 2008 02:39PM
Re: declarar una variable dentro de un Procedure??
3407
December 03, 2008 02:24PM
2878
April 05, 2009 02:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.