Details
Grants
References
Dependencies
Code
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 ;