My Oracle Support Banner

EBS: How to Execute Shell Script With Host Command In Oracle Forms 10g (Doc ID 2940358.1)

Last updated on APRIL 05, 2023

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

We have a requirement to run a shell script from forms to perform some action. We have a small piece of code written in WHEN-NEW-RECORD-INSTANCE trigger, which is like below.

BEGIN
  HOST('/bin/sh/myscript.sh',NO_SCREEN);
END;

Shell script is not getting executed with the above approach. Also, we don't see any error as well anywhere.

Shell script and its folder were given 777 permissions and they are available for access and execution across the application server box.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.