DB Audit - Mail alerts without UTL_SMTP

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?

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?

I will take a look at DB Mail as it might be a better solution to my workaround.

Thanks for the suggestion.

Mike Braganca

: 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)