Re: Executing UNIX shell commands from trigger

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/02/27
Message-ID: <34f74a2c.3199405_at_www.sigov.si>#1/1

On Fri, 27 Feb 1998 11:20:10 +0000, Jhansi Rani <p_jhansi_at_hotmail.com> wrote:

>Ofcourse you can use HOST command to execute Unix commands in triggers
>in a server. I have extensively used HOST commands in triggers like
>when-new-form-instance, when-new-block-instance etc. in Forms 4.5.
>
>Regards
>Jhansi

You executed HOST commands from *application* (i.e. FORMS) triggers, which are executed on client side, not on server side. From server side PL/SQL (i.e database stored procedures, functions, packages, triggers) you can't execute OS commands (at least not in Oracle7), unless you use a listener program and DBMS_PIPE package.

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Feb 27 1998 - 00:00:00 CET