Re: declarar una variable dentro de un Procedure??
Hola que tal Mauricio
Así debería funcionar:
BEGIN
set @vIdCliente=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
Saludos
Miguel Martinez
Celaya, Mexico
Edited 1 time(s). Last edit at 11/24/2008 12:50PM by Miguel Martinez.
Subject
Views
Written By
Posted
27536
November 24, 2008 10:35AM
Re: declarar una variable dentro de un Procedure??
5477
November 24, 2008 12:47PM
4002
November 24, 2008 02:39PM
3408
December 03, 2008 02:24PM
2879
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.