CREATE OR REPLACE TRIGGER trig_toms_demo
AFTER INSERT OR UPDATE OR DELETE ON gxjhxm
FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
ht_htbh ht.htbh%type;
BEGIN
IF INSERTING THEN
SELECT count(*) INTO ht_htbh FROM gxjyk.ht;
END IF;
END;
求大神解惑