Unhandled Exception on Oracle Form Builder

From: Tommy DN <_at_nospam.com>
Date: Tue, 30 Nov 2004 12:13:35 +0100
Message-ID: <krCdnSNo3p5ByDHcRVnyvg@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 I'm working with.

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 - 05:13:35 CST