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