Unhandled Exception on Oracle Form Builder
From: Tommy DN <"Tommy>
Date: Tue, 30 Nov 2004 12:13:35 +0100
Message-ID: <krCdnSNo3p5ByDHcRVnyvg_at_scarlet.biz>
I'm working with Oracle Form Builder and I needed a trigger to check something when I delete a record. I made a trigger on ' KEY-DELREC ' and I've written this code ( it's just a test, the delete statement isn't ready ):
DECLARE
aantal number(8);
BEGIN
END;
Date: Tue, 30 Nov 2004 12:13:35 +0100
Message-ID: <krCdnSNo3p5ByDHcRVnyvg_at_scarlet.biz>
I'm working with Oracle Form Builder and I needed a trigger to check something when I delete a record. I made a trigger on ' KEY-DELREC ' and I've written this code ( it's just a test, the delete statement isn't ready ):
DECLARE
aantal number(8);
BEGIN
select count(*)
into aantal
from voorstellingen v
where :zalen.zaalnr = v.zaalnr;
show_error_alert('This query has ' + aantal + ' records');
raise form_trigger_failure;
END;
LITTLE EXPLANATION:
Another table called 'voorstellingen' can have zero or more records with
zaalnr as foreign key ( voorstnr as primary key, but this doesn't
matter, I think ). When this table has one or more records, it may not
be deleted. ':zalen.zaalnr' is the primary key of the table 'zalen' wich
THE PROBLEM:
When I perform this, the code above should give me a message about how
many records the table voorstellingen has. But when I perform it I
receive an unhandled exception: " ORA-06502: PL/SQL: numeric or value
error string ".
Can someone help me please ??? Received on Tue Nov 30 2004 - 12:13:35 CET