Compilation errors to send email with TRIGGER sql
<p>Hello i'm working on PL/SQL Developper and i've got an annoying error ... I'm trying to make a trigger to send an email when something is added in the "JDEF" database.
This is my code :</p>

<pre><code>CREATE OR REPLACE TRIGGER Send_Email
AFTER INSERT
ON JDEF
BEGIN 
        EXEC msdb.dbo.sp_send_dbmail
             @profile_name = 'me',
             @recipients = 'example@ent.com',
             @body = 'The stored procedure finished successfully.',
             @subject = 'Automated Success Message'
END
</code></pre>

<p>The error compilation are for those two lines : EXEC msdb.dbo.sp_send_dbmail AND @profile_name = 'me'. They speak about "MSDB" and ",' symbols who are replaced by other one to compile.</p>

<p>Have you any ideas to help me ?</p>

<p>thx</p>