Details

Grants

References

Dependencies

Code


NAME VALUE
OWNER DWH_TIENDAS_ADM
OBJECT_NAME N_EMPLEADOS_TR1
SUBOBJECT_NAME null
OBJECT_ID 24675
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
ESTADISTICAS_DIRECCION DWH_TIENDAS_ADM TABLE 24649 VALID TABLE
PKG_EST_DIR DWH_TIENDAS_ADM PACKAGE 24665 VALID PACKAGE
N_EMPLEADOS DWH_TIENDAS_ADM TABLE 24647 VALID TABLE
TRIGGER N_EMPLEADOS_TR1 
BEFORE UPDATE OF NUMERO_EMPLEADOS ON N_EMPLEADOS 

DECLARE
  rsp_temp STRING (200);
BEGIN
  PKG_EST_DIR.ACTLZR_EST_GLOBAL(rsp_temp);
END;