Hi,

there is no need for stored procedure..

You can do it by making foreign key with delete cascade