17,140
社区成员




CREATE OR REPLACE TRIGGER tri_del_type
BEFORE DELETE
ON bale_type_info
FOR EACH ROW
DECLARE
pragma autonomous_transaction;
BEGIN
EXECUTE IMMEDIATE 'alter table bale_info disable primary key cascade';
DELETE FROM bale_info t WHERE t.type_id=:old.type_id;
EXECUTE IMMEDIATE 'alter table bale_info ENABLE primary KEY';
END;