Hi,
I found this in section 4.27.2 Characteristics of SQL-invoked routines:
> If a <routine invocation> is contained in a <query expression> of a
> view, a check constraint, or an assertion, the <triggered action> of a
****************
> trigger, or in an <SQL-invoked routine>, then the subject routine for
> that invocation is determined at the time the view is created, the
> check constraint is defined, the assertion is created, the trigger is
> created, or the SQL-invoked routine is created.
So it would appear that Derby's present behavior is wrong.
Thanks,
Dag
