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