Re: Can RDBMS interact with its OS environment?

In article <8e7lt4$v6f$1_at_nnrp1.deja.com>,   Eugene Fan <terp182_at_hotmail.com> wrote:
> 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
>

There is no native way to issue OS commands from pl/sql, but you can use the dbms_pipe package and a deamon style program or external procedures to accomplish what you describe.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.