Details

Grants

References

Dependencies

Code


NAME VALUE
OWNER CARTERAINVERSION_USER
OBJECT_NAME INSBEFOREACCIONHISTORICO
SUBOBJECT_NAME null
OBJECT_ID 28321
DATA_OBJECT_ID null
OBJECT_TYPE TRIGGER
CREATED 11/06/15
LAST_DDL_TIME 11/06/15
TIMESTAMP 2015-06-11:22:56:09
STATUS VALID
TEMPORARY N
GENERATED N
SECONDARY N
NAMESPACE 3
EDITION_NAME null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME OWNER TYPE OBJECT_ID STATUS TYPE_LINK
NAME OWNER TYPE OBJECT_ID STATUS TYPE_LINK
ACCIONHISTORICO CARTERAINVERSION_USER TABLE 28251 VALID TABLE
TRIGGER insBEFOREAccionHistorico BEFORE INSERT  ON ACCIONHISTORICO
FOR EACH ROW
DECLARE
maximaFechaCierre date;
BEGIN

SELECT MAX(FechaCierre) INTO maximaFechaCierre
	FROM AccionHistorico;

	/* no podemos pasar cotizaciones anteriores a la Ășltima fecha introducida */
	IF (maximaFechaCierre > :new.FechaCierre) THEN
		RAISE_APPLICATION_ERROR (-20020, 'La fecha de cierre ' || :new.FechaCierre ||
								' es inferior a la Ășltima introducida ' || maximaFechaCierre );
	END IF;
END insBEFOREAccionHistorico ;