Run a .sh from an oracle forms 12c

Iker Garcia Martin

Hi,

I want to run a .sh file from an oracle forms . Is it possible?

if possible, how is it done?

Environment data:

Oracle Weblogic: 12.2.1.4

Oracle Forms: 12.2.1.4

SO. Oracle Linux 8

Thanks,

Iker

Michael Ferrante-Oracle

If you want to run it on the server (mid tier) you would use the Forms built-in HOST. Refer to the Form Builder Help for details. In short, the call might look something like this:

HOST ('/home/iker/myscripts/foo.sh &');

Michael Ferrante-Oracle

If you want to run it on the server (mid tier) you would use the Forms built-in HOST. Refer to the Form Builder Help for details. In short, the call might look something like this:

HOST ('/home/iker/myscripts/foo.sh &');

Iker Garcia Martin

Thanks Michael, it is OK

Iker Garcia Martin

Michael,

How can I go through and collect the parameters in the sh?

The command in oracle forms is:

host('/tmp/prueba.sh &"/tmp/'||''''||v_fichero||''''||'"');

The file .sh is:

echo $1

cd /tmp

/usr/bin/chmod 777 &1

/usr/bin/rm &1

Michael Ferrante-Oracle

Why are you trying to delete files in /tmp from a shell script called from Forms? Why not just directly delete the file(s)?

HOST ('/usr/bin/rm /tmp/"' || v_fichero ||'"');

Iker Garcia Martin

yes, but it's for testing a simple .sh file

Michael Ferrante-Oracle

@Iker Garcia Martin

I'm sorry, you said "Yes, but...". I don't understand what you are saying. I said, "why not just directly delete the file".

What exactly are you trying to accomplish if not what you described in this thread?

Iker Garcia Martin

What I mean is that it is an example .sh file to try something easy and that works