Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Unhandled Exception on Oracle Form Builder
Hi Tommy,
this answer only to one Group..
Try || and not + to concatenate some strings.
You may use to_char(antaal)..
Rgds Dirk
"Tommy DN" <"Tommy DN"@nospam.com> schrieb im Newsbeitrag
news: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
> 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 - 06:10:04 CST