Details

Grants

References

Dependencies

Code


NAME VALUE
OWNER DWH_TIENDAS_ADM
OBJECT_NAME TIENDAS_TR2
SUBOBJECT_NAME null
OBJECT_ID 24674
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_TR2
BEFORE UPDATE OF NOMBRE_CIUDAD ON TIENDAS 
FOR EACH ROW
BEGIN

  IF :old.VIRTUAL = 0 THEN
    raise_application_error (-20002, 'No se puede cambiar la ciudad de una tienda física.');
  END IF;

END;