Here is the header from the default procedure CREATE OR REPLACE PROCEDURE db_audit.sp_audit_sendmail ( mail_server IN VARCHAR2, -- name or IP address of your smtp mail server sender IN VARCHAR2, -- your email address recipient IN VARCHAR2, -- recipients' email address cc IN VARCHAR2, -- CC addresses or NULL if none subject IN VARCHAR2, -- mail message subject message IN VARCHAR2 -- mail message body ) If you create your own procedure with the same signature DB Audit will use instead of the default procedure. By the way, do you know about DB Mail software that we make? It also uses DBMS_PIPE for commmunications and it is capable to send all kinds of messages, email, faxes, network popups. Soon it will also able to dial ou and send voice messages (either prerecorded or created dynamically using text-to-speach technologies) : I note from your documentation that you use UTL_SMTP to send e-mail alerts : from your stored procedures. : Our ORACLE database (8.1.7) does not have java implemented, so I cannot use : UTL_SMTP. We have a workaround using DBMS_PIPE. Is there any way I can : substitute my PL/SQL SP for UTL_SMTP and still get email alerts from your : product?
|