Details

Grants

References

Dependencies

Code


NAME VALUE
OWNER DWH_TIENDAS_ADM
OBJECT_NAME TIENDAS_TR1
SUBOBJECT_NAME null
OBJECT_ID 24673
DATA_OBJECT_ID null
OBJECT_TYPE TRIGGER
CREATED 08/01/16
LAST_DDL_TIME 08/01/16
TIMESTAMP 2016-01-08:12:26:20
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
TIENDAS DWH_TIENDAS_ADM TABLE 24633 VALID TABLE
TRIGGER TIENDAS_TR1 
BEFORE UPDATE OF FRANQUICIA, VIRTUAL ON TIENDAS 
FOR EACH ROW

BEGIN
  IF 
    :new.FRANQUICIA <> :old.FRANQUICIA OR
    :new.VIRTUAL <> :old.VIRTUAL
  THEN
    RAISE_APPLICATION_ERROR (-20001, 'Campos franquicia y virtual no se pueden actualizar.');
  END IF;
   
END;