I tried this with a process, when delete button pressed:
Delete product from product_prices where product_id = :P22_PRODUCT_ID;
Commit;
Delete product from products where product_id = :P22_PRODUCT_ID;
Commit;
But nothing happens.
When I insert datas that process works:
insert into shop(shop_id, shop_name)
values(:shop_id, shop_name);
commit;
insert into product(product_id, product_name)
values(:product_id, product_name);
commit;
insert into product_prices(product_id, product_name)
values(:product_id, product_price, shop_id);
commit;
Why works that with insert and why does not work with delete?