in the trigger

execute procedure multiply(10,20) returning new.field;

On 18/01/07, Daniel Albuschat <d.albuschat@...> wrote:
> Hi there,
>
> I'm looking for the correct syntax to set a field in a trigger to a
> value retrieved from a
> stored procedure.
>
> Here's a simplified examle (I'm not doing multiplication, but some other, more
> complex calculations):
>
> create procedure multiply(a integer, b integer) returns(c integer) as
> begin
> c = :a*:b;
> end^
>
> create trigger test_trigger for test active before insert as
> begin
> new.field = multiply(10,20); /* I'm looking for the correct syntax
> to do this */
> end^