Oracle Forms 6i and Host() Function

From: silly white boy <wildone_at_planetearth.com>
Date: Tue, 14 May 2002 00:17:48 GMT
Message-ID: <njl0euc2bt77h141q2bhfjopb0e6qkrle9_at_4ax.com>

I have a host script on a UNIX server that I would like to call from an Oracle form running on Applications 11i. The host script will ftp a file. I have run the script in UNIX and it runs successfully. Full access is assigned to all the files and directories involved. In my form I have the line:
Trigger attached to a button...
Host('[path to shell script]/[file name] [param1] [param2]');

The problem is that the script never executes. I do not receive any form errors. The only time I did get a message is when I used an exception looking at Form_success. It was set to false. Can anyone out there provide any insight on what may be the problem? The only examples I have seen have windows calls in the Host() function, never UNIX.

Thanks in advance!

C. Kern Received on Tue May 14 2002 - 02:17:48 CEST