TRIGGER

Hi,

My trigger :

CREATE TRIGGER delete_pays
BEFORE DELETE ON PAYS
FOR EACH ROW
DECLARE
X number;

BEGIN
select count(*) into X
from ville V
where V.CodePays=:old.CodePays;

dbms_output.put_line(' '||X||' rows will delete, confirm (y/n);

?

if rep='Y' then
delete from ville V
where V.CodePays=:old.CodePays;
END; Instead of ? i like to tell to users a confirmation, how ?

Regards.

E-Mail -> lafon_at_msdos.montpellier.inra.fr Received on Mon Jun 26 1995 - 00:00:00 CEST