Can RDBMS interact with its OS environment?

From: Eugene Fan <terp182_at_hotmail.com>
Date: 2000/04/26
Message-ID: <8e7lt4$v6f$1@nnrp1.deja.com>#1/1

Hi,

I was wondering if a database trigger can call some PL/SQL package that will allow it to issue a command to the operating system hosting the database.

For example, if I insert a row into a table, I want to use mailx or sendmail,
whatever is available on the database server machine to send an email to designated user(s).

Can one of the DBMS_ or UTL_ packages do it? I think something under UTL_ allows you to write to a file on the filesystem, but how would you invoke the mailx command? Is there something like a HOST(" ") command?

TIA

---

Eugene Fan
CEXEC / IMCEN Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 26 2000 - 00:00:00 CDT