On Tue, 01 Nov 2011 10:00:38 +1300, Helen Borrie <helebor@...>
wrote:

> At 07:56 AM 1/11/2011, you wrote:
>>On 31-10-2011 17:46, grip_2ls wrote:
>>> Hi Mark
>>>
>>> Thanks for the advise but I don't think that is the issue. If you
>>> remove the second select statement it compiles and runs fine.
>>
>>That was exactly the issue I was pointing out. You are using SELECT
>>without INTO to call SendMail. That doesn't work as Sean also pointed

out.

>
> Furthermore, invoking that Sendmail procedure as a select procedure is

not

> sensible in this environment or any other. Make it an executable

procedure

> and, in the trigger code, call it with EXECUTE PROCEDURE (:var1, :var2,
> etc.) Selectable procedures are intended to return sets and shouldn't

be

> used to execute DML.

Helen, it was actually a singleton select against RDB$DATABASE calling the
SendMail UDF in the column list.